I have two tables (same worksheet), each with a single column. Both tables contain names only (Doe, John).
I would like to create a third table, single column only of all the names in Tables 1 and 2 that can be sorted alphabetically.
Preferably skipping blank cells.
So far, my attempts will only sort numerically and only data from the first table. Blank cells show as zeroes.
Have had no luck with Power Query.
I would like to create a third table, single column only of all the names in Tables 1 and 2 that can be sorted alphabetically.
Preferably skipping blank cells.
So far, my attempts will only sort numerically and only data from the first table. Blank cells show as zeroes.
Have had no luck with Power Query.