Excel or Access change some rows to columns

Question

I have some long data I need to convert into a wide fixed width text format. I have a large spreadsheet of rows that are duplicated for each person where the only difference, where the person is the same, are two columns. I want to remove the duplicates and instead of having multiple rows where the only difference are the columns 'type' and 'process'. They are all in the same row and repeated 30 times each, some columns would be blank if there are not 30 rows for that person. I've attached a picture if my explanation makes no sense: I'm not sure if this can be done in VBA, or python or other language would be better JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

Answer 1

You can do that using a pivot table: put name then DOB as row labels put type then process as column labels put count of process in values right-click your pivot table, select expand/collapse and expand by process go to design, report layout, and select tabular layout right click on totals rows and columns that you do not want and hide them Here's how it looks for me, for a smaller table: