Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transpose data Months & Data to Rows
Here is what I have:
Title Title Title Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec A B C 5 6 7 8 9 10 11 12 13 14 15 16 I want to bring the months and the data down as rows underneath the ABC group, now I do have about 1500 rows like this. So, ultimately I need to add 12 rows underneath each current row, add the months in a column and add the data for the corresponding month in a new column titled "data". Let me know if you need more information...THANKS! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transpose Data from a column to several rows | Excel Worksheet Functions | |||
Data: select a cell x rows below the current, where x is designate | Excel Discussion (Misc queries) | |||
ranking query | Excel Discussion (Misc queries) | |||
Showing only rows with data | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) |