| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
assistance needed: transpose data from rows to columns
excel 2007
i have about 60k rows of data in this format: Month Jan Day 1 Year 2010 Month Feb Day 2 Year 2011 Month Mar Day 3 Year 2012 i need to convert it into this format: Month Day Year Jan 1 2010 Feb 2 2011 Mar 3 2012 help please! thank you! Last edited by etanretla : July 26th 12 at 05:47 PM |
|
#2
|
|||
|
|||
|
Quote:
Hi, Have a look at the attachment. I think this does what you mean. |
|
#3
|
|||
|
|||
|
hi spencer...yes, you are correct...do you know of a way to convert data from 'table a' to 'table b'?
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Transpose data from columns to rows | Excel Discussion (Misc queries) | |||
| how to transpose a large data from columns into rows | Excel Discussion (Misc queries) | |||
| how to transpose a large data from columns into rows | Excel Discussion (Misc queries) | |||
| Transpose data from rows into columns | Excel Programming | |||
| Transpose after finding criteria assistance needed. | Excel Programming | |||
Hybrid Mode
