Hi,
can anybody help me in this task as in the header?
Example can be this one... but... i have sheet with about 30thousands of rows with these values
So, the example:
A B
1 a
1 b
1 c
1 d
2 aa
2 bb
result can be:
A B C
1 a a b c d
1 b a b c d
1 c a b c d
1 d a b c d
2 aa aa bb
2 bb aa bb
Thank you very much,
Pavel
Bookmarks