We help IT Professionals succeed at work.
Get Started

Move Columns to Rows in Excel

LRI1 asked
Last Modified: 2012-05-11
I have a rather large spreadsheet of data that I need to export as a CSV file so I can import into a database.  My issue is the data is populated horizontally based on the key field (employee ID).  What I would like to do it take the data and move it vertically so the CSV file will be in the format I need.  Copy and paste special - transpose will work, however this spreadsheet is huge and will take a lot of time to transpose.  I also thought about using MS Query and or Crystal Reports to get my data in the correct format.  Any idea's how I could accomplish this task?  Possibly with an option I outlined above or some programming or formula?  I have included a small screen shot of what the layout currently is and what I am looking to achieve.  Thank you.

Screen shot example
Watch Question
Top Expert 2010
This problem has been solved!
Unlock 1 Answer and 5 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE