| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Transpose into comma-delimited row
I have several worksheets where I need to take rows of data like:
Row1 Row2 ABCDEF 12 GHIJKL 34 MNOPQR 56 And I want to transpose that into 2 comma-delimited rows like: Row1 ABCDEF,GHIJKL,MNOPQR Row2 12,34,56 The paste special function separates the data into columns. I probably need to write a macro but I don't have much experience doing that. I appreciate the help in getting this done. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving as tab delimited or comma delimited | Excel Discussion (Misc queries) | |||
| Tab delimited to comma delimited | Excel Worksheet Functions | |||
| Comma Delimited-need comma at beginnng & end | Excel Discussion (Misc queries) | |||
| Comma Delimited Numbers | Excel Discussion (Misc queries) | |||
| Comma delimited question | Excel Discussion (Misc queries) | |||
Threaded Mode
