Hello!
I have 4 rows and a bunch of columns that I want to transpose into 4 columns and a bunch of rows. When I use the transpose tool, it only turns my first row into a column. Is there a way I can use the transpose tool to transpose all 4 columns at once rather than filtering and running 4 difference streams with transpose? Thanks!
Solved! Go to Solution.
Hi @km007!
Do you have a sample of your data?
Maybe you'd have to use the Cross Tab Tool to achieve what you want.
Cheers,
Yes! For example,
Row Number Column A Column B Column C
Row 1 1000 3000 2000
Row 2 2000 3000 1000
Row 3 1000 3000 4000
When I use the transpose tool with no Key Field selected and all Data Fields selected, I get the following result:
Name Row 1
Column A 1000
Column B 3000
Column C 2000
However, I would also like Row 2 and Row 3 as additional columns to look something like this:
Name Row 1 Row 2 Row 3
Column A 1000 2000 1000
Column B 3000 3000 3000
Column C 2000 1000 4000
Attached is the solution. Following the Transpose, you'll need a Cross Tab:
- Group data by: NAME
- New Column: Row Number
- New Values: Value
Cheers,
Mark
Thanks everyone! That makes a lot of sense. I didn't realize that all the values were stacked on top of each other in that one column and thought it had just cut some out.