Putting data from columns into rows
 

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.

Putting data from columns into rows
 

copypaste specialtranspose
delete the old data

"Pistols14" wrote:

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.