Transposing multiple data columns

[Dominic_Albans]

Hi, 

I have a data set currently arranged like this: 

Date	Identifier	Cost	Revenue
09/08/2024	ABCD	5	10
12/08/2024	ABCD	10	15
13/08/2024	ABCD	15	20

I want this data set to be re-arranged like:

Identifier	COST: 09/08/2024	COST: 12/08/2024	COST: 13/08/2024	REVENUE: 09/08/2024	REVENUE: 12/08/2024	REVENUE: 13/08/2024
ABCD	5	10	15	10	15	20

Can anyone help?

[griffinwelsh · Accepted solution]

@Dominic_Albans See the attached workflow. Please mark this thread solved if this fits your usecase or let me know if you have any questions.

[binuacs · Accepted solution]

@Dominic_Albans similar to @Dominic_Albans approach