I have 70+ sheets of data. Each sheet is for just one location on a certain date. There are several time recordings for each date with values for pH, temperature etc (see 'input'). How do I get it into the form ('output') without copying and pasting over and over again? I basically need the 'input' data in a form that can be used for a pivot chart.
Input:
Output:
I've attempted using the indirect function with match/index to sort of reference the worksheet but I'm not smart enough to figure it out. Also, looked at 'relationships' but that's not worked. Any suggestions?
