Transposing The Data

[akshayhendre]

Hello All, I have data in this format 

Weekend	New Cases	Old Count	Completed Cases
2020-03-29	4	12	5
2020-04-05	5	23	7
2020-04-12	8	5	3
2020-04-19	0	21	8

and would like to have in below format

	Data as of 2020-03-29	Data as of 2020-04-05	Data as of 2020-04-12	Data as of 2020-04-19	Till Date Count
New Case	4	5	8	0	17
Old Cases	12	23	5	21	61
Completed Cases	5	7	3	8	23

So would like to know that what could be the best approach to have the desired output.

[grossal]

All columns that you want to use in your "New Column Name Formula" have to be either Key Columns in the Transpose Tool or being created after the Transpose.

In my case "Weekend" was a Key Column in the Transpose and "ID" is created using the Multi-Row-Formula behind the Transpose (and before the New Column Name Formula).

I hope this helps. If it does not help, feel free to attach your current attempt and I'll take a look.