To rearrange data in specific format

Question

Hi team,

Please help to achieve below specific output format:

Input file:

EntityAmounts to be givenAmounts to be takenA42B53C64

Output file:(Required format)

ValuesABCAmounts to be given456Amounts to be taken234

Thanks in advance:)

Polite123 · Answer

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:)

FrederikE · Answer

Hey @Polite123,

Transpose Tool with the following settings will do the trick.

JosephSerpis · Answer

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

Transpose_Crosstab_20092022.yxmd