Merging Cells based on some criteria

Appreciate it if anybody can share share some codes on how to merge cells based on some criteria:

Example: There are 7 rows in column A containing 2 rows for "Andrea", 1 for "Bryan" and 4 for "Cloe". I want to have 2 merged cells in columun B for "Andrea", 1 for "Bryan" and 4 merged cells for "Cloe".

Note that the number of times data will repeat in column A will vary.

See attached file for better example.

Thanks!!