1

I have daily data for different sites organized as shown here:

I'd like to organize the previous data using Excel to look this figure:

I have tried using pivot table to change rows into columns but it didn't work with me. It would be highly appreciated if you could help me organize it.

fixer1234
  • 28,064

1 Answers1

0

You can select the dating row at a time, right click where you want the column to begin, go Paste Special... in the context menu, and select Transpose.

enter image description here

PFitz
  • 2,528