Parts from single sentence going to next row?

[AnaLG]

Hi, 

I am trying to fix the format of this table in Alteryx, so for example the content of 'responsibilities' row 5 is part of row 4 and should not be in a different row. How could I fix this? Thank you in advance!

[Jonathan-Sherman · Accepted solution]

Hi @AnaLG,

You could use a combination of multi-row and summarise to consolidate and concatenate the rows into one. I've attached my example.

Kind regards,

Jonathan

[AnaLG]

Thank you so much @Jonathan-Sherman. What would happen if there was no brackets or numbers in the column 'Responsibilities'?