Change direction of Excel data from horizontal to vertical

[mtdew]

I have an Excel file that looks like this:

Column A - A part of a waste disposal system used to disburse the waste water into the ground.
Column B - Abstract of Title
Column C - Absorption Trench
Column D - Abstraction Method
Column E - Abut
Column F - 2

But I need it to look like this:

Row 1 Q:A part of a waste disposal system used to disburse the waste water into the ground.
Row 2 A:Abstract of Title
Row 3 A:Absorption Trench
Row 4 A:Abstraction Method
Row 5 A:Abut
Row 6 A:
Row 7 A:
Row 8 S:M2
Row 9 R:
Row 10 I:
Row 11 O:1111111

So the original sheet has everything running horizontally and I need it to run vertically. I tried to copy and paste after getting the first set correct but the formula automatically skips 10 rows.

Any suggestions?

 

[Kurupt55]

Highlight all, right click, copy, select cell A1, right click, past special, select Transpose, select ok.

This should do it

Impossible is Nothing

 

[Kurupt55]

Actually on second look, what does the Q: A: S: mean?
and what is skipping 10 rows?

Impossible is Nothing

 

[mtdew]

Those are some items I wanted to add to the data when it is transposed so that I can use it with a javascript program. I was able to accomplish adding those items in by creating a formula that looked like this:

="Q:"&'Sheet1'!A6

But once I got the info correct for the first set which took up 11 rows the formula automatically added 10 to the next formula so it would read

="Q:"&'Sheet1'!A16

when it should have read

="Q:"&'Sheet1'!A7