I have multiple values in cells different columns but in same row e.g.
1;2;3;4;5 and a;b;c;d;e
I would like to separate them to one value in each cell in different rows but keep relationship with corresponding value in next column....So the data above will show up in two different column but 5 different rows
1 a
2 b
3 c
4 d
5 e
Thanks for your help
Bookmarks