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!
