I need to merge rows with same Name preserving data of each column. For example, if we have two rows with the name "Mr Bean" on the first column "Name" then merge data of each column related to rows named "Mr Bean", then delete the second and third rows, putting all data in only the first row named "Mr Bean". So, we should have all data related to a single person in one row instead in more than one row.
+-------------------------------------------------------+
| Column Name Column 2 Column 3 Column 4 Column 5 |
| Mr Bean 2 3 |
| Mr Bean 2 3 5 |
| Mr X 3 3 |
| Mr Y 2 4 1 3 |
+-------------------------------------------------------+
Desired output:
+-------------------------------------------------------+
| Column Name Column 2 Column 3 Column 4 Column 5 |
| Mr Bean 2 3, 2 3 5 |
| Mr X 3 3 |
| Mr Y 2 4 1 3 |
+-------------------------------------------------------+
My Excel file has about 4000 rows and 450 columns.