Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transpose Data with fixed first column
I am trying to transpose data, I thought of using a pivot table, but my data
would exceed the 256 columns going across, so is there another way to the following: Existing Data looks like this: A B 1 Product Type 2 Icecream Cholocate 3 Icecream Strawberry 4 Icecream Vanilla 5 Coffee Hazelnut 6 Coffee Pumpkin 7 Tea Green 8 Tea Black 9 Tea Chai 10 Tea White I want to transpose data to looks like this: Product Type Type Type Type Icecream Cholocate Strawberry Vanilla Coffee Hazelnut Pumpkin Tea Green Black Chai White Any help will be great. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transpose column into rows for use as mailmerge data | Excel Discussion (Misc queries) | |||
Transpose data from many horizontal rows into a single column | Excel Discussion (Misc queries) | |||
Transpose Data from a column to several rows | Excel Worksheet Functions | |||
I have a column of data and I'd like to transpose it to go across. | Excel Discussion (Misc queries) | |||
How do I transpose an Excel 2003 column of data? | New Users to Excel |