Multiple rows to multiple columns

[felipeecst]

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!

[jdunkerley79 · Accepted solution]

I'd suggest something like:

- Transpose to get Item, Name, Value

- Then Formula Tool to join Item to Name

- Finally a Cross Tab to convert to the horizontal form.

This doesn'r result in the initial Item column though. Sample attached.

[felipeecst]

That's exactly what I needed :)

Thank you!