Hi everyone,
I need help with the following:
I have a list of 150 names in a single spreadsheet row, and I want to insert 4 modified versions of each name between each unique name for the whole row.
So let's say for example we have:
Andrew, Bill, Courtney in a row.
I want to end up with:
Andrew Black, Andrew Red, Andrew Blue, Andrew Green, Bill Black, Bill Red, Bill Blue, Bill Green, Courtney Black, Courtney Red, Courtney Blue, Courtney Green, and so on.
Can someone help me with a macro to automate this, as doing this manually for 150 cells will be quite tedious.
Thanks in advance
Bookmarks