1
so this seems tricky to me but i have a set of data that need to be split into alternating comlumns here is what i mean is in the example below i split column A to C E and G ect depending on how many sets of data are in the cell seperated my a comma and then seperate comlumn B into the alternating comlumns D F and H ect ect
| Column A | Column B | Column C | Column D | Column E | Column F | Column G |Column H |
| A, B, C | X, Y, Z | A | X | B | Y | C | Z |
somthing like above and my ultimate goal is to achive
| Column J |
|A, X, B, Y, C, Z |
please if anyone can help it is much appreciated
if this is a 1-off problem that does not need automatic solution, see Splitting concatenated Excel columns at spaces? and other Related anwers listed here
– Aprillion – 2015-01-15T10:47:20.627