| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text Columns to Rows
I have a worksheet that I would like to change all rows to columns -- a
pivottable would work perfectly if text could be shown in the data area. Is there a way to do this? If not, my table has 3 columns: Key Code Country Text Code 1 US xxxxxxxxx Code 1 China xxxxxxxx Code 1 UK xxxxxxxxxx Code 2 US xxxxxx Code 3 China xxxxxx Code 3 UK xxxxxx I want change the table to be Code US China UK 1 xxxxxx xxxxxx xxxxxx 2 xxxxxxx 3 xxxxxx xxxxxx Can someone tell me how that can be done??? Thank you! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Wrap Text Across Columns & Rows | Excel Discussion (Misc queries) | |||
| How to copy some text in columns and rest in rows | Excel Discussion (Misc queries) | |||
| Each rows last cell text value could be in any columns. | Excel Worksheet Functions | |||
| Converting text from rows to columns | Excel Worksheet Functions | |||
| text data in one column many rows to many columns one row | Excel Discussion (Misc queries) | |||
Threaded Mode
