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
There are about 20 Items that could be assigned to a name, They are fixed.
NAme 1 Item 1 Name 1 Item 2 Name 1 Item 3 Name 2 Item 1 Name 2 Item 2
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
Bookmarks