Rotating an excel spread sheet - swapping columns & rows

Firstly I have no idea if this is possible and was hoping there might be a simple(ish) solution!

I have been supplied a spread sheet that I need to import into ms/my sql with a list of companies and what they do.

Currently the companies are in the columns and what they do in the rows.

I need to have the companies in the row, with what they do in the columns.

In essence rotating it through 90 degrees.

Hoping someone can help - many thanks in advance


Who is Participating?
jppintoConnect With a Mentor Commented:
Can you Copy- Paste Special-Transpose your data into another sheet to see if it's what you want?

jimyXConnect With a Mentor Commented:
Let's assume your data are from A1 to J12 then
Select all your data (A1 to J12) and "Copy", then go to new sheet and "Paste-Special" and check "Transpose" then OK.
Buzby58Author Commented:
That's got to be a record response time - many thanks to you both - easy when you know how!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.