Rows to Columns

[Daniela_Arenzana]

I'm sure the solution might be quite simple but I'm kind of stuck... I need to transpose multiple rows into columns.

This is what it looks like:

KPI	Value
A	10
B	20
C	30
D	40

This is what I need:

A	B	C	D
10	20	30	40

Any suggestions? Thank you very much in advance!

[dougperez · Accepted solution]

Hello @Daniela_Arenzana 

To do that, you will need to use the cross tab tool: