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?
@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.
@Dominic_Albans similar to @Dominic_Albans approach