Thanks in advance for the help.
I have a spreadsheet of around 40,000+ rows (and growing) which I need help getting to transpose.
Raw data is in column A to C and looks like the below
<tbody>
Date time
Name
Temperature
<tbody>
1/10/2018 1:55:49
</tbody>
C1tc1
18.35
<tbody>...