Data Transformation Required

Hi All,

Attached spreadsheet contains two tabs "Current" & "Required". "Current" contains the data that needs to be converted into the format present in "Required" Tab.

I have a huge file, 127MB, with 0.2 million rows of such data & I really need help in getting the data transformed.

Thank you.

Kind Regards,
theabdulrab.