Hi everyone
I have data that currently looks like this
Product A | ||||
January 2024 | February 2024 | March 2024 | ||
null | Revenue | 10 | 11 | 12 |
null | Cost | 1 | 2 | 3 |
null | Profit | 9 | 9 | 9 |
LOCAL | ||||
INVESTMENT | ||||
Product B | ||||
null | 00:00:00:00 | 00:00:00:00 | 00:00:00:00 | |
null | Revenue | 20 | 21 | 22 |
Cost | 10 | 9 | 8 | |
Profit | 10 | 12 | 14 | |
Product C | ||||
00:00:00:00 | 00:00:00:00 | 00:00:00:00 | ||
null | Revenue | 30 | 31 | 32 |
null | Cost | 15 | 14 | 13 |
Profit | 15 | 17 | 19 |
I'm trying to get it into a more tabular/database format:
Product | Revenue | Cost | Profit | Date |
Product A | 10 | 1 | 9 | January 2024 |
Product B | 20 | 10 | 10 | January 2024 |
Product C | 30 | 15 | 15 | January 2024 |
Product A... | 11.... | 2.... | 9.... | February 2024... |
...and so on |
You can ignore/omit the other text/strings/words like "null"s, "LOCAL","INVESTMENT", and 00:00:00.
Thanks for any help!
Solved! Go to Solution.
Hi @D_Y - see workflow attached.
@D_Y - update to fix date order
Thank you @Bren_Spill !