I want to take the description to the left of ":" and make a column heading and put the detail to the right of ":" below the headings:
DBV:1
RTX:AE-941/PLACEBO
VIN:AE941PL
ALRDIN:9999999A
DBV:2
RTX:ALVAC CEA/B7.1
VIN:ALVST
ALRDIN:9999999A
DBV:3
RTX:ANASTROZOL MA 27 STUDY
VIN:ANA1TST
ALRDIN:02224135
Want it to look like:
DVB RTX VIN ALRDIN
1
2
3
DBV:1
RTX:AE-941/PLACEBO
VIN:AE941PL
ALRDIN:9999999A
DBV:2
RTX:ALVAC CEA/B7.1
VIN:ALVST
ALRDIN:9999999A
DBV:3
RTX:ANASTROZOL MA 27 STUDY
VIN:ANA1TST
ALRDIN:02224135
Want it to look like:
DVB RTX VIN ALRDIN
1
2
3