How to transpose more than 1 row at a time?

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!

Tips and Tricks

Accepted answers

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

Solve of transpose.yxmd

All comments

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

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15878

MarqueeCrew 13708

apathetichell 13703