I have this seen solution http://www.excelfox.com/forum/f22/re...ata-as-is-420/ but it puts everything in one column.

I want to split the delimited column into a fixed number of columns, specifically two.

Example Input:

Column A | Column B
1 | A, B, C, D, E
2 | F, G, H, I, K, L, M, N, O
3 | P, Q, R, S

Example Output:

Column A | Column B | Column C
1 | A | B
1 | C | D
1 | E
2 | F | G
2 | H | I
2 | K | L
2 | M | N
2 | O
3 | P | Q
3 | R | S