Convert blank row data in colums

Closed
Report
-
Hello,

how we convert blank row data in column

Data Name
50 V10
V12
V3
V6
51 V1
V2
V4
V5
V7
52 V8
53 V9
55 V11
57 V13
58 V14
Grand Total

i want result look as a below

Data Name Name Name Name Name
50 V10 V12 V3 V6
51 V1 V2 V4 V5 V7
52 V8
53 V9
55 V11
57 V13
58 V14
Grand Total


please confirm VBA script and pivot table function so that i can this