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?
Hi Julian and welcome to the Community!
can you please provide an example?
See attached spreadsheet. It has 2 sheets: “input” and “output”.
Example.xlsx (8.9 KB)
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)
Here is another variant – with a bit more complicated logic, but it can work with any number of columns.
split2.morph (2.8 KB)
These are great solutions. Thank you for the quick reply and help!
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.