Hi all,
I have Sheet2 with names per row from ColA to ColL. Some rows have names in all 12 cells, other rows do not.
I need to fill out all the empty cells per each row up to ColL with names from Sheet1 ColA, with the condition that there will be no duplicates per each row.
I'm attaching an example that displays Sheet1 as the names pool, Sheet2 as the data sheet with blank cells per each row in A-L range, and Sheet3 which displays the desired outcome after filling out empty cells per each row with unique names from Sheet1, so that there's no name repeated in the same row.
Can I get some precious assistance with this question, please?
Always, many thanks in advance ..
T.
Bookmarks