Split multiple column using delimiter

Hi how would i acheive this

I have a table which has 2 columns, both with delimiters.

I need to split the columns into rows using the delimiters, but maintain the matching sequence between the 2 columns.

For example:

Original table

Col1 Col2

a,b,c x,y,z

I want the new table to be
|a|x|
|b|y|
|c|z|

Hey Antony,

Copy and paste this snippet into a flow to get started.

parabola:cb:47ed9ba4189941818c5d6db44edca605

It’s a tricky problem that took more steps than I’d like, but it should work for you.

This toggle explains how the flow works, if you're interested.

Essentially, this snippet takes a CSV with two columns, as you described, and splits the values into two separate tables, one for each column. Then it splits the “a,b,c” values into three separate columns. Then we can flip the tables on their side so we have

|Col. 1|
|a|
|b|
|c|

We do these steps for both columns.

and then we just stitch the two separate tables back into one, using a Combine Tables step.

Does this work for what you need?

1 Like

You are legendary, that should work, i wonder if there was a unique id for each row, would we follow the same step

1 Like

Thanks Antony, glad it works for you.

What do you mean a unique ID for each row?

The final steps give a dummy row number and combine the tables based on that value. So if you had real row IDs or something like that, you could use those as the key value to combining your tables.

hi thanks for your response, i was using an airtable base, so i could utilise the airtable unique row id instead of adding a new row number

1 Like

i should probably have mentioned this first, then the steps would have been more compact

1 Like