Convert Rows into Columns then Subtract

[BenJones13]

Hi Community!

Currently, a filter of my data looks like this:

22/01/2023	1009105
22/01/2023	137006.5
22/01/2023	30242.15
22/01/2023	7766.04
22/01/2023	-5374.11
22/01/2023	38267.42
22/01/2023	31613.48

And I want to transpose them into this:

22/01/2023	22/01/2023	22/01/2023	22/01/2023	22/01/2023	22/01/2023	22/01/2023
1009105.1	137006.53	30242.15	7766.04	-5374.11	38267.42	31613.48

Then I will be able to subtract all the values from the first one. Unless there is an easier way to do this?

[ShankerV · Accepted solution]

Hi @BenJones13 

Please find the expected output.

Many thanks

Shanker V

[BenJones13]

Thank you Shanker!