Hi there,
I have a problem that I just can't wrap my head around. I've been scouring the internet for the last 3 hours and have tried multiple different approaches but haven't managed it yet.
I have a list of data, this will get longer over time.
data2.PNG
What I would like to do is then sort it into an intelligent format. I will only ever get one reading per month from each ID point. This is what I am trying to make the data look like:
Data.PNG
I'm at my wits end - I normally manage to find an answer myself, but I am now reaching out for help to the experts. Thanks in advance for your advice.
Bookmarks