Hi
I have a little problem by transpose and reorganize some data.
My input data:
Number1 Number2 Value
1 2 Z
1 2 x
1 2 y
1 2 m
2 2 Z
2 2 x
2 2 y
2 2 m
2 2 n
My wish to output data:
Number1 Number2 Value1 Value2 Value3 Value4 Value5
1 2 z x y m
2 2 z x y m n
Any good idea how to transpose and reorganize this data to my wish?
BTW: I'am using execl 2010
Thanks.
BR
Michael
Bookmarks