How to get all the unique distinct value from a list in Excel

[evilgreenred]

Hi there

I had a group of list from column B to column D with different number of rows. How should I get all the unique distinct value such that once there is any letter appear in the list, it will print out as from what you had seen in Column F? Since the list contains A-G, it will print the output from A to G. Thanks.

[#2]

@evilgreenred 

For example (if you have Microsoft 365 or use Excel Online):

=SORT(UNIQUE(VSTACK(OFFSET(B2:B51, 0, 0, COUNTA(B2:B51)), OFFSET(C2:C51, 0, 0, COUNTA(C2:C51)), OFFSET(D2:D51, 0, 0, COUNTA(D2:D51)))))

[#3]

@evilgreenred 

You may also try this...

=SORT(UNIQUE(TOCOL(B2:D8,1)))

[#4]

@evilgreenred 

Or

=SORT(UNIQUE(VSTACK(FILTER(B2:B51,B2:B51<>""), FILTER(C2:C51, C2:C51<>""), FILTER(D2:D51, D2:D51<>""))))