My data is set out as below.
I have a column for date(A), energy type(B) and 48(B-AX) columns for time (00:00-23:30) with 30 min intervals.
The data is set out so that the date is the same for 3 rows(A2-A4), energy type is unique for B2-B4 (W, var, VA) and the range (C2-AX5) contains values specific to the time.
I would like to convert the data so that
There are four columns date & time column, and three columns for (W , var , VA). How do I loop through the data so that at each change in date the relevant range containing w, var, VA is transposed into the three columns ? (as in below)
Thanks in advance.
I have a column for date(A), energy type(B) and 48(B-AX) columns for time (00:00-23:30) with 30 min intervals.

The data is set out so that the date is the same for 3 rows(A2-A4), energy type is unique for B2-B4 (W, var, VA) and the range (C2-AX5) contains values specific to the time.
I would like to convert the data so that
There are four columns date & time column, and three columns for (W , var , VA). How do I loop through the data so that at each change in date the relevant range containing w, var, VA is transposed into the three columns ? (as in below)

Thanks in advance.