Pivot to transpose-need help

Hi

I need to make data from pivot table-


I have this format-

Row BASIC_CC RIDER_CC
SEP SEP1
ADB7
ADB7 - RC16
CR65
EP27
EP75
SEP2
ADB7
ADB7 - RC16
CI14
CR65
CR65 - CW30
EP27

AEN AEN2
AB19
AB20
AD05
AD09
AD16

need to get like-
Actuallly i need to transpose- Total data i have around 2300 rows.

SEP SEP1 ADB7 ADB7 - RC16 CR65 EP27 EP75
SEP2 ADB7 ADB7 - RC16 CI14 CR65 CR65 - CW30 EP27 EP75 EW81 SIR5
AEN AEN2 AB19 AB20 AD05 AD09 AD16


Thanks in advance

Hi,
As required find sample in excel.


Sample.xlsx