# Split multiple column using delimiter **URL:** \ **Category:** Ask a question\ **Created:** [June 10, 2021, 8:03am UTC](https://community.parabola.io/t/split-multiple-column-using-delimiter/1850 "2021-06-10T08:03:10Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![ANTONY\_RAPPAI](https://avatars.discourse-cdn.com/v4/letter/a/90ced4/32.png) [@ANTONY\_RAPPAI](https://community.parabola.io/u/ANTONY_RAPPAI)\ **Post date:** [June 10, 2021, 8:03am UTC](https://community.parabola.io/t/split-multiple-column-using-delimiter/1850/1 "2021-06-10T08:03:11Z")
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| ---
**Author:** ![Brian\_Dawson](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/brian_dawson/32/1454_2.png) [@Brian\_Dawson](https://community.parabola.io/u/Brian_Dawson)\ **Post date:** [June 10, 2021, 12:27pm UTC](https://community.parabola.io/t/split-multiple-column-using-delimiter/1850/2 "2021-06-10T12:27:37Z")
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? ---
**Author:** ![ANTONY\_RAPPAI](https://avatars.discourse-cdn.com/v4/letter/a/90ced4/32.png) [@ANTONY\_RAPPAI](https://community.parabola.io/u/ANTONY_RAPPAI)\ **Post date:** [June 10, 2021, 12:32pm UTC](https://community.parabola.io/t/split-multiple-column-using-delimiter/1850/3 "2021-06-10T12:32:18Z")
You are legendary, that should work, i wonder if there was a unique id for each row, would we follow the same step ---
**Author:** ![Brian\_Dawson](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/brian_dawson/32/1454_2.png) [@Brian\_Dawson](https://community.parabola.io/u/Brian_Dawson)\ **Post date:** [June 10, 2021, 12:38pm UTC](https://community.parabola.io/t/split-multiple-column-using-delimiter/1850/4 "2021-06-10T12:38:43Z")
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. ---
**Author:** ![ANTONY\_RAPPAI](https://avatars.discourse-cdn.com/v4/letter/a/90ced4/32.png) [@ANTONY\_RAPPAI](https://community.parabola.io/u/ANTONY_RAPPAI)\ **Post date:** [June 11, 2021, 4:55am UTC](https://community.parabola.io/t/split-multiple-column-using-delimiter/1850/5 "2021-06-11T04:55:41Z")
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 ---
**Author:** ![ANTONY\_RAPPAI](https://avatars.discourse-cdn.com/v4/letter/a/90ced4/32.png) [@ANTONY\_RAPPAI](https://community.parabola.io/u/ANTONY_RAPPAI)\ **Post date:** [June 11, 2021, 4:58am UTC](https://community.parabola.io/t/split-multiple-column-using-delimiter/1850/6 "2021-06-11T04:58:00Z")
i should probably have mentioned this first, then the steps would have been more compact ---
**Author:** ![ANTONY\_RAPPAI](https://avatars.discourse-cdn.com/v4/letter/a/90ced4/32.png) [@ANTONY\_RAPPAI](https://community.parabola.io/u/ANTONY_RAPPAI)\ **Post date:** [July 16, 2021, 1:38pm UTC](https://community.parabola.io/t/split-multiple-column-using-delimiter/1850/7 "2021-07-16T13:38:47Z")
Hi there, i am still a bit confused, i am trying to achieve this for the following format of data, i have a class id unique column **Class ID - Rotation Day Number - Rotation Period Number** DP1-Math - 1,3,5,6 - 2,4,1,3 DP1-Science - 3,4,5,8 - 1,2,1,3 DP2-Math - 1,6,7,8 - 1,4,3,4 The end result needs to be DP1-Math - 1 - 2 DP1-Math - 3 - 4 DP1-Math - 5 - 1 D1-Math - 6 - 3 So on and so forth thanks for you help ---
**Author:** ![Adam\_R](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/adam_r/32/2207_2.png) [@Adam\_R](https://community.parabola.io/u/Adam_R)\ **Post date:** [July 16, 2021, 5:23pm UTC](https://community.parabola.io/t/split-multiple-column-using-delimiter/1850/8 "2021-07-16T17:23:31Z")
Hey @ANTONY_RAPPAI 👋 I pasted your sample data into a Google Sheet and was able to generate these results with this flow: ![Screen Shot 2021-07-16 at 10.19.48 AM](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/3/31b4322bc52831aeecf9a97389f67db95b4fc31f.png) ![Screen Shot 2021-07-16 at 10.20.29 AM](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/2/26e24f6ca75a3aeea30dbb2e9481e16e9c69438e.jpeg) Feel free to paste this snippet into your flow to follow this approach: parabola:cb:45f171e3037544f08b7c435eaff06fe6 I also put together [this quick video](https://www.loom.com/share/8622fc2a7344474a89d945972e3aadd3) to help make sense of the flow. Let me know if you have any questions! ---
**Author:** ![ANTONY\_RAPPAI](https://avatars.discourse-cdn.com/v4/letter/a/90ced4/32.png) [@ANTONY\_RAPPAI](https://community.parabola.io/u/ANTONY_RAPPAI)\ **Post date:** [July 16, 2021, 6:06pm UTC](https://community.parabola.io/t/split-multiple-column-using-delimiter/1850/9 "2021-07-16T18:06:55Z")
Thank you, that works. Excellent video too, you explained it really well