Macro to convert a Flat Data with many Headings to a Database with few Headings

Hello All Experts,

I have cross tabular data as shown in the Before Sheet

I want a macro to convert it to a database as shown on After Sheet

There is only one sheet in the Workbook. The macro should create the After Sheet

Last row of the data should be excluded

Headings start from A1 till across

Data starts from A2 till down

Headings with numbers in parentheses should be splitted into two Columns viz DT & CC

Col L to S should be transposed against the each Name

Col U to AA should be transposed against each Name

Columns T, AB & AC to be ignored

After sheet shows only Name1 for explanation purpose

The macro should run for all Names

Any help would be greatly appreciated

Thanks in advance

Rehana