Cleanup of data that is merged by client and requires text to columns and transposing

Data is received in "example 1" tab. Client account is a merged cell (Column A) that has contact names and emails in individual rows per client in columns B and C. The names and emails are all in one cell and are delimited by semicolons. Text to columns can easily break out these values into individual columns for each value but the merged cell in column A does not have the right number of rows to easily transpose the data from columns to rows. Doing this manually required me to count how many names/emails there were per client and then adding/removing rows to account for the transpose (which is extremely time consuming when there are 20 clients with 10-15 contacts per client).

Does anyone have a more efficient way of getting from the "Example 1" tab to the "Solution" tab?

I used Power Query to do this.

Convert your data into a table, load it into Power Query, fill Client Account down, duplicate the query so you now have two.
On the one, split Contact Names by delimiter (semicolon) into rows, then add an index column
On the other, split Contact Emails by delimiter (semicolon) into rows, then add an index column
Use the index column to Merge Queries and pull over Contact Emails from the other into the first one.
Delete the columns that you don't need.

See attached.

This worked great - thank you for the quick response!