Forum Discussion
Combine text split across multiple rows
If there is consistency with the way rows with Symbol and CUSIP are related to the rows with blank values above them:
You can do this (mostly with the interface)-
Replace blank or space values with null.
Do a Fill Up on the 2 columns.
Do a 'Group By' on Symbol and CUSIP with one aggregation (pick Min, we will edit this in the next step)
Edit the last step in the formula bar to replace 'List.Min' with 'Text.Combine'.
--
It will be a little bit more complicated with other columns but that's the start
Community ChampionIf there is consistency with the way rows with Symbol and CUSIP are related to the rows with blank values above them:
You can do this (mostly with the interface)-
Replace blank or space values with null.
Do a Fill Up on the 2 columns.
Do a 'Group By' on Symbol and CUSIP with one aggregation (pick Min, we will edit this in the next step)
Edit the last step in the formula bar to replace 'List.Min' with 'Text.Combine'.
--
It will be a little bit more complicated with other columns but that's the start
That worked perfectly. Thank you very much!
