• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 475
  • Last Modified:

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

Grant



0
Buzby58
Asked:
Buzby58
2 Solutions
 
jppintoCommented:
Can you Copy- Paste Special-Transpose your data into another sheet to see if it's what you want?

jppinto
0
 
jimyXCommented:
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.
0
 
Buzby58Author Commented:
That's got to be a record response time - many thanks to you both - easy when you know how!
0
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now