Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Coverting data from some columns to rows (but not the primary colu
I have some data that i want to layout in a different format. At present it
is as follows: Name, Property1, Property2, ... Property172 abc, 786 7684 8965 abd 645 64573 64328 .... (there are 2007 rows) although there are 172 columns there may not necessarily be an entry in every column for each name. I want it to be in the format Name, Property abc, 786 abc, 7684 abc, 8965 abd, 645 abd, 64573 abd, 64328 Can anybody help? Thanks ;o) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find data in columns, then place in rows | Excel Worksheet Functions | |||
How to swap rows and columns? | Excel Discussion (Misc queries) | |||
Putting data into pivot tables in columns not rows. | Excel Discussion (Misc queries) | |||
coverting rows to columns | Excel Worksheet Functions | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |