Convert Columns to Rows

[JAgger1]

How does one change columns of numbers to rows of numbers?

ie:
8 16 31
2 14 16
12 15 46
3 13 15
8 38 50
8 38 40
9 14 26

to

8 2 12 3 8 8 9
16 14 15 13 38 38 14
31 16 46 15 50 40 26

 

[smartin]

How does one change columns of numbers to rows of numbers?

ie:
8 16 31
2 14 16
12 15 46
3 13 15
8 38 50
8 38 40
9 14 26

to

8 2 12 3 8 8 9
16 14 15 13 38 38 14
31 16 46 15 50 40 26

Select the original range, Copy, place the cursor elsewhere, Edit |
Paste Special | tick "Transpose" | OK.

 

[JAgger1]

Perfect, thanks

Question, how come I can only go 255 columns wide?

 

[smartin]

Perfect, thanks

Question, how come I can only go 255 columns wide?

An unfortunate limitation of Excel. There are a few workarounds you
could try. Google "excel column limit" for examples.

 

[Dave Peterson]

There are 256 columns in versions of excel before xl2007.

There are 16384 columns in xl2007.

What version are you using?

 

[Chris Bode via OfficeKB.com]

Please follow following steps
1.Right click on the toolbar> click Control Box
2.From the control box that appears on your screen, select a command button
and draw it to your sheet
3.Double click the command button and write following codes in code window
Now paste following codes
#
Private Sub CommandButton1_Click()
Dim row As Integer, col As Integer

row = 1
col = 1


Dim rowinsheet2 As Integer, colinsheet2 As Integer

rowinsheet2 = 1
For col = 1 To 3
row = 1
colinsheet2 = 1

While Sheet1.Cells(row, col).Value <> ""


Sheet2.Cells(rowinsheet2, colinsheet2).Value = Sheet1.Cells(row,
col).Value

colinsheet2 = colinsheet2 + 1

row = row + 1

Wend
rowinsheet2 = rowinsheet2 + 1
Next
End Sub
#

Have a nice time….


Chris