Is there an automatic way of doing the "transpose " by batch in Excel..?
I have thousands of records in the excel sheet having this kind of format:
I want to put it this way in a single excel sheet :
field1 field2 field3 field4
record1 company address phone
record2 company address phone
record3 company address phone
record4 company address phone
Im doing it manually..Copy the 1st record then "Paste Special" then check the "Transpose"
I there a batch transpose'..? or formula on this ..Thanks'