Hi!
I have the following table I need to clean up. I've been trying a lot of different approaches without any luck - so I need some help!
The dataset is attached and looks like this:
What I want to achieve is to have a date column with all dates, and that the repeating headers are added as single headers with the values from each date unioned.
The end result should look like this:
