Tutorials & Examples Web-help Blog

Advanced Split with Multiple Columns


#1

I have a spreadsheet with two columns that both contain comma-separated values where the 1st value of column A coincides with the 1st value of column B, the 2nd value of column A coincides with the 2nd value of column B. How would I go about properly splitting these two columns into rows and ensuring the right values are aligned?


#2

Hi Julian and welcome to the Community!

can you please provide an example?


#3

See attached spreadsheet. It has 2 sheets: “input” and “output”.

Example.xlsx (8.9 KB)


#4

You can split each column into rows separately, and then append columns using the “Append” action in the “Append columns” mode.

See the example below:

split.morph (3.5 KB)


#5

Here is another variant – with a bit more complicated logic, but it can work with any number of columns.

split2.morph (2.8 KB)
image


#6

These are great solutions. Thank you for the quick reply and help!


#7

Wouldn’t it be better to just add the feature in the split columns to split all values to multiple columns.
Now It just takes the first value from the first column. I think this is an important feature where multiple users would benefit from.