Arranging data using Transform tools

[Tid14]

Hi,

I am working on a workflow where I need to arrange my columns accordingly to get the desired output, where my 3 columns become rows and rest are same. 

I have attached an input file and the output of what i wanted.

Any idea on how I can get this visibilty?

Thanks in Advance :)

[IraWatt]

Hey @Tid14,

Is this the kind of set up your looking for:

Any questions or issues please ask :)
HTH!
Ira

[Tid14]

Hi @IraWatt,

Thanks for the help but what I am looking for is little different. I want these 4 rows also that are coming in the first column (before SAP). How to get this visibility?

	SAP	Randy's report	Difference
Randy's report total
264400 YI
264404 YI
Total

[IraWatt · Accepted solution]

Ah sorry @Tid14, here's an updated workflow:

[Tid14]

Thank you so much @IraWatt .

This looks perfect :)

[IraWatt]

Great to hear @Tid14 😄 let me know if you have any questions. 

[binuacs]

@Tid14 One way of doing this with the table tool