I Have a table in Excel that current look like this
Name 1 Item 1, Item 2, Item 3
Name 2 Item 1, Item 2

With 650+ Rows. What I need it for it to look like this
NAme 1 Item 1
Name 1 Item 2
Name 1 Item 3
Name 2 Item 1
Name 2 Item 2
There are about 20 Items that could be assigned to a name, They are fixed.

Is there a way to create a macro or series of macros the car make this change, as doing it by hand is going to take way too long.

Thanks in advance
Rab