| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I move items from columns into rows without cut/paste?
I have exported information from our billing system and it has put each
individual item as a separate line item in a single column. For all items belonging to the same customer, I need them to be on the same line. (ie line 1, column a, column b, column c etc. ) in order to merge them into a letter in a word document. Is there an easier way than cutting and pasting each item in the row to the next column? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I move items from columns into rows without cut/paste?
look in the help index for TRANSPOSE
-- Don Guillett SalesAid Software "Biller" wrote in message ... I have exported information from our billing system and it has put each individual item as a separate line item in a single column. For all items belonging to the same customer, I need them to be on the same line. (ie line 1, column a, column b, column c etc. ) in order to merge them into a letter in a word document. Is there an easier way than cutting and pasting each item in the row to the next column? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I move data in prexisting rows to columns? | Excel Worksheet Functions | |||
| REQ: Columns to rows or Rows to Columns | Excel Discussion (Misc queries) | |||
| convert columns to rows & rows to columns | Excel Discussion (Misc queries) | |||
| Move rows to columns | Excel Worksheet Functions | |||
| interchange columns with rows | Excel Discussion (Misc queries) | |||
Linear Mode
