Text to rows within a list

[jodillee]

Hi you amazing excel minds. I have been having problems with a rooming list and I know there must be a simple solution. I'm not really good with code and wouldnt really know how to apply it but my problem is this:

I have a spreadsheet which pulls from our system and imports to excel with names backwards and all merged into one cell as per the "capture" attachment.
Ideally I would like to split the names at the comma but have the text after the comma inserted in a new row below.

I ultimately want the list to show the clients names in the proper order. Currently I have to split the text by inserting new empty columns in firstly and using the Text to columns function with the comma delimited. I then have to insert a new row on every other line below and paste the second client name below the first. Once they are all lined up I then use the text to columns function again with the delimiter by space so it separates them out with the title, surname and first name in separate columns. I then have to cut and paste the Mr/Mrs title column to the front of the name so it shows in the correct order. I ideally want the list to look like the second attachment. Is there an easier way of doing this because it is ridiculously labour intensive for what it is!

Can any body help?