Generating row data based on a variable amount of info under it

Cmcguire

I have a csv file that is formatted like so:

List:Birds, 9
Penguin, 3
Cardinal, 4
Robbin, 2
List:Cats, 2
Tabby, 2
...

Everything under the item belong and sum to the list total, until the next list is stated. I'm struggling to convert the data to one row so that it would look like the following:

List:Birds, 9, Penguin, 3, Cardinal, 4, Robbin, 2

List:Cats, 2, Tabby, 2

...

Am I missing an easy solution to do this?

AngelosPachis

Hi @Cmcguire ,

You can flag the different groups with a multi-row formula and then use a summarize tool to concatenate all relevant strings together

Hope that helps,

Angelos

example.yxmd