Taking multiple columns and stacking in to one column

Hello!!! New to the forum and so happy to have found this! I am having a major issue!!! Here is the set up:

Column A: Name
Column B: Counties

Hundreds of records. Column B could consist of 1 County or 25 Counties. Every row is different. I do a simple 'text to column' creating multiple columns each with a county name.

I need for every row to be only 1 name and 1 county so that I can create pivot tables. In order to do this, I need for all of the counties to be in 1 single column with the corresponding name in column A on the same row. I have uploaded a sample sheet to show what I am talking about. I'm assuming a macro or VBA is warranted here because when I am dealing with hundreds of rows this becomes an impossible project. Any help here would be greatly appreciated!

Oh my God YOU ARE A GENIUS!!!!!!!! Do you know how long I have been struggling with this!?!??! You just made my MONTH! THANK YOU, THANK YOU, THANK YOU!!!!!!!!