Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Arrange data spanning 8 columns and 3 rows to 24 columns and 1 row | Excel Discussion (Misc queries) | |||
Putting columns back in alpha order | Excel Worksheet Functions | |||
insert columns macro is putting 2 columns instead of 1 | Excel Worksheet Functions | |||
Putting many columns into one | Excel Discussion (Misc queries) | |||
Putting data into pivot tables in columns not rows. | Excel Discussion (Misc queries) |