How to sequence a 364 rows into one column

Copper Contributor

example

 

Row B2 - AW2 to change to a column sequence.  There are 365 rows to be changed in the same format into the same column

 

Context

Row B2 to AW2 is electricity measurements in 30 min increments 

Column A is the date

 

 

1 Reply
=TRANSPOSE(B2:AW365)