| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| two dimension look up table | Excel Worksheet Functions | |||
| Flat File with @ as delimiter | Excel Discussion (Misc queries) | |||
| Matrix Dimension | Excel Worksheet Functions | |||
| Flat file security | Excel Discussion (Misc queries) | |||
| Flat File | Excel Discussion (Misc queries) | |||
Threaded Mode
