Sorting data
Sorting data
(OP)
Community,
I have numerical data in Excel in the following column format:
A B C D
E F G H
etc.
where A, B etc = a number
The data is 4 columns (A B C D) x 1251 rows. I would really like to have this data sorted into the format
A
B
C
D
...
Any ideas?
Many thanks.
I have numerical data in Excel in the following column format:
A B C D
E F G H
etc.
where A, B etc = a number
The data is 4 columns (A B C D) x 1251 rows. I would really like to have this data sorted into the format
A
B
C
D
...
Any ideas?
Many thanks.
------------
See FAQ569-1083 for details on how to make best use of Eng-Tips.com
Talk To Other Members
RE: Sorting data
CODE
'
' proper Macro
For j = 1 To 1251 Step 1
Range(Cells(j, 1), Cells(j, 4)).Select
Selection.Copy
Range(Cells((j * 4) + 1, 6), Cells((j * 4) + 1, 6)).Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=True
Next j
End Sub
------------
See FAQ569-1083 for details on how to make best use of Eng-Tips.com
RE: Sorting data
RE: Sorting data
Select your range (A1:D1251)
Copy
Select a new worksheet, cell A1
Right click, PasteSpecial - Transpose (at the bottom of the dialog box)