Is there any way in Excel to reformat data so that data which is listed in
columnar format can be copied into rows. For instance if the data is listed
from cells a1:a4 and I want to reinput this data into cells a1, b1, c1 and d1.

Any help would be appreciated.