| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine multiple rows into one.
I am trying to combine multiple rows into one. The data is in five columns.
The main identifiers are the first few characters of column A (F75 through F77 with varying number of occurances). I would like to extract each grouping (first F75 row through F77 row and so on) and place into one row. A space in between data would be fine as I imagine I could do a text to column delimit later. Here is an example of what it looks like. I am truncating the data for ease of viewing. Thank you in advance. F75 00141 09022 0 F75 F75 0712 0 F76 08 010 0 F76 09022009 0 F77 0 F75 00141 090 0 F75 24 2 F75 090 01 F76 08 01 0 F76 090 0 F76 08 01 0 F76 09 0 F77 0 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| combine multiple rows in one column | Excel Worksheet Functions | |||
| How to combine information from multiple rows into one | Excel Discussion (Misc queries) | |||
| combine contents of multiple rows in one row | Excel Discussion (Misc queries) | |||
| How do I combine multiple rows with like data in Excel? | Excel Discussion (Misc queries) | |||
| Combine Data from Multiple Rows | Excel Discussion (Misc queries) | |||
Threaded Mode
