switching rows with columns..is it possible?

N

nixis00

Hallo,

I'd like to know if I could swap data from rows and columns:
e.g.
from:
1 2 3 4
a
b
c
d

in:
a b c d
1
2
3
4

without doing too much edit or similar...

I have a huge raw data file that needs to get sorted.

th
 
J

JulieD

Hi
you can copy the range & then paste /special - transpose - i would suggest
doing the paste in a new worksheet

i've not done HUGE data ranges but it seems to work fine for the ones i've
tested it on - remember however, you've only got 256 columns

Cheers
JulieD
 
I

icestationzbra

i can think of one way:

once you import all your data from the text file onto a sheet in
workbook, copy all the data, and Paste Special - Transpose
 
Top