Thread: assistance needed: transpose data from rows to columns
View Single Post
  #1   Report Post  
etanretla etanretla is offline
Junior Member
  
Posts: 2
Default 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
Reply With QuoteReply With Quote