Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiple rows to single row
I have Data which is like
a 1 a 2 a 3 b 1 b 2 This I would like to regroup this as following a 1 2 3 b 1 2 and so on. Issue is - Number of times a .... appears is not fixed. Number of unique ä,b in column is not fixed All data is text only, as an example I used numbers here. Help appreciated. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving data from multiple rows to single rows | Excel Worksheet Functions | |||
Moving data from multiple rows into a single row | Excel Discussion (Misc queries) | |||
Sum single or duplicate rows with multiple criteria | Excel Worksheet Functions | |||
HELP!! ARRANGE MULTIPLE ROWS IN A SINGLE ROW | Excel Worksheet Functions | |||
Multiple rows from a single row | Excel Discussion (Misc queries) |