ExcelBanter - assistance needed: transpose data from rows to columns

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - assistance needed: transpose data from rows to columns (https://www.excelbanter.com/new-users-excel/446685-assistance-needed-transpose-data-rows-columns.html)

etanretla

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!

Spencer101

1 Attachment(s)

Quote:

Originally Posted by etanretla (Post 1604040)

Hi,

Have a look at the attachment.
I think this does what you mean.

etanretla

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

All times are GMT +1. The time now is 03:26 PM.