To rearrange data in specific format

[Polite123]

Hi team,

Please help to achieve below specific output format:

Input file:

Entity	Amounts to be given	Amounts to be taken
A	4	2
B	5	3
C	6	4

Output file:(Required format)

Values	A	B	C
Amounts to be given	4	5	6
Amounts to be taken	2	3	4

Thanks in advance:)

[JosephSerpis]

Hi @Polite123 you can achieve your output using a Transpose and a Crosstab tool.

[FrederikE]

Hey @Polite123,

Transpose Tool with the following settings will do the trick. 

[Polite123]

Hi @JosephSerpis ,

Thanks for the quick reply.

The logic is working but actually I am trying to create Summary sheet with this and the output of your workflow arranges the data alphabetically

Example the output comes out to be in order A,B and then C.

But I require some thing like C, A and then B.

Could you please help with the above logic?

Thanks again in advance:)