2 dimension matrix conversion to flat records
How do I take a large 2 dimensional matrix of data and easily create flat
records instead. Cutting and pasting is not an option considering the
original matrix is a huge 2 dimensional spreadsheet. The sample below has
been simplified
Current matrix
ITEM 1/7/2008 1/21/2008 2/4/2008 2/18/2008
Zinnia - mix 111 122 133 104
Petunia - Blue 205 226 27 28
Petunia - Red 399 310 311 312
Desired matrix - flat record
Item Date Quantity
Zinnia - mix 1/7/2008 111
Zinnia - mix 1/21/2008 122
Zinnia - mix 2/4/2008 133
Zinnia - mix 2/18/2008 104
Petunia - Blue 1/7/2008 205
Petunia - Blue 1/21/2008 226
Petunia - Blue 2/4/2008 27
Petunia - Blue 2/18/2008 28
Petunia - Red 1/7/2008 399
Petunia - Red 1/21/2008 310
Petunia - Red 2/4/2008 311
Petunia - Red 2/18/2008 312
|