Sep 28 2021 02:43 PM
I have this set of 5000 data points.
The data is from different years and are identified by the value in the first column. I am trying to get rid of the duplicate entry and combine the values from the separate years into a single row with the value in the first column.
What is the fastest way to do this?
Picture on left is what data looks like, photo on right is what I'm trying to achieve.
Sep 28 2021 07:06 PM