Hi everyone,
I have a large dataset where I need to shift up the values of several columns for the same ID, as in the attached spreadsheet. The table at the top is the format of my original data; I need to bring it in the format of the second table, at the bottom.
Not sure yet how to approach it, or even if it's possible to do this with Excel formulas.
Any pointers would be appreciated.
Thanks!
Bookmarks