Hi everyone,
I have the following table:
Item | Attr1 | Attr2 | Attr3 |
A | X | W | R |
B | Y | Z | S |
I want to transform it into the following:
Item | A-Attr1 | A-Attr2 | A-Attr3 | B-Attr1 | B-Attr2 | B-Attr3 |
A | X | W | R | Y | Z | S |
I was able to do that by using multiple Crosstabs and Append Fields in sequence (example attached), but I believe there is a more elegant way to do this. Also, the number of attributes can grow and this approach would become unmanageable.
Can anyone help me finding a better solution?
Thanks in advance!
Solved! Go to Solution.
That's exactly what I needed :)
Thank you!