I have a requirement to perform the following transformation , but im not sure how i could go about it. Ive been trying to play around with it, but my efforts have led to dead ends
![Sad :(](./images/smilies/icon_sad.gif)
Brand---- code---------- Position
A------ 1 ----------------- X
A------ 1 ----------------- Y
A------ 1 ----------- Z
B------ 2 --------------- U
B--------- 2 ----------------- V
This should convert to
Brand ---- Code--- Position1--- Position2--- Position 3
A ---------- 1 ------- X---------- Y----------- Z
B ------------ 2 ------ U-----------V
Ideally i would like to convert it to :
Brand -----Code -- Position
A ----------- 1----- XYZ
B ------------2----- UV
I dont know which one is easier to do, if at all feasible.
Thanks for your time and help!