• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 472
  • 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

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

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