python - Excel or Access change some rows to columns -

i have long data need convert wide fixed width text format.

i have large spreadsheet of rows duplicated each person difference, person same, 2 columns.

i want remove duplicates , instead of having multiple rows difference columns 'type' , 'process'. in same row , repeated 30 times each, columns blank if there not 30 rows person. i've attached picture if explanation makes no sense:

i'm not sure if can done in vba, or python or other language better

you can using pivot table:

• put name dob row labels
• put type process column labels
• put count of process in values
• right-click pivot table, select expand/collapse , expand process
• go design, report layout, , select tabular layout
• right click on totals rows , columns not want , hide them

here's how looks me, smaller table: