I have 20 spreadsheets with data only in A column.
Now I want to move them all to one row of 1 spreadsheet but the problem is the data is till A100000 cell, which means I can only paste it in A B C D E F and so on ....
Now I want to check and delete any duplicates that is in Column A with other columns.
I have created a sample file.
Please check and advice me on how can I just keep the unique entries in each cell.
I have marked the red ones that should get removed automatically as the data is already in another cell.
Please help.
Ethan
Bookmarks