View Single Post
  #2   Report Post  
Spencer101 Spencer101 is offline
Senior Member
 
Posts: 663
Default

Quote:
Originally Posted by etanretla View Post
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!

Hi,

Have a look at the attachment.
I think this does what you mean.
Attached Files
File Type: zip etanretla example.zip (6.1 KB, 71 views)