Quote:
Originally Posted by 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!
|
Hi,
Have a look at the attachment.
I think this does what you mean.