How to transpose more than 1 row at a time?

[km007]

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! 

[Thableaus]

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,

[km007]

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

[MarqueeCrew · Accepted solution]

@km007,

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

[Thableaus]

Use the Transpose tool and the Ctab tool after that.

Workflow attached.

[km007]

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.