| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i rotate data - see below
I have data (lots of it - 200k lines) that looks like this:
Row/Column A B 1 RABBIT 123 2 RABBIT 887 3 RABBIT 455 4 PIG 336 5 PIG 723 I want this to look like: Row/Column A B C D 1 RABBIT 123 887 455 2 PIG 336 723 I know that I can transpose each one in turn, but that would take weeks. Is there someone clever out there ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I rotate data in Excel table (rows to columns, and vv)? | Excel Discussion (Misc queries) | |||
| importing from Access & need to rotate data--can't transpose--HELP | Excel Discussion (Misc queries) | |||
| Rotate data by date | Excel Discussion (Misc queries) | |||
| How do I rotate data in a spreadsheet so that rows become columns? | Excel Discussion (Misc queries) | |||
| How I do I rotate text in an excel cell? The rotate commands is g. | Excel Discussion (Misc queries) | |||
Threaded Mode
