transposing data
i have a maximum of 48 rows
Thanks
"Sriram" wrote:
hi,
i have data in the below format in excel
A 1
B 2
C 3
D 4
(empty row)
(empty row)
A 5
B 6
C 7
D 8
and it runs into few hundred thousand rows, is there any way in which i
could transpose data in the format
A B C D
1 2 3 4
5 6 7 8
without having to paste special and then transpose record by record
Thanks
|