Within the same workbook three worksheets all have the same column of information. All three worksheets have many more blanks than data. I need to copy the non-blank values of all three and then paste only the non-duplicated values into sheet 4. Example:
Sheet1 - input 1
A
blank
B
C
Sheet2 - input 2
B
blank
blank
C
D
Sheet3 - input 3
F
blank
blank
A
B
Sheet4 - result, sorted copy of one and only one instance of all the values on sheets 1, 2 and 3, without blanks
A
B
C
D
F
Thanks in advance for your help!
Bookmarks