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)