assistance needed: transpose data from rows to columns

E

etanretla

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

+-------------------------------------------------------------------
+-------------------------------------------------------------------
 
E

etanretla

hi spencer...yes, you are correct...do you know of a way to convert dat
from 'table a' to 'table b'

+-------------------------------------------------------------------
+-------------------------------------------------------------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Choose append field based on criteria 4
Calculating occupational sick pay entitlement 0
Transpose 1
Help with determining # of days from certain dates 2
2 dimensional date sort 2
Pivot table - show monthly data based on start/end date data 0
Function Problem 6
Help showing active months between two dates 5

Top