FILTERXML - combine multiple columns into one Unique List - Excel
In this video, I demonstrate how to combine or append multiple columns into one column using FILTERXML and the Unique function. Unique function easily works with single rows or columns, but with multiple columns requires some creativity. The FILTERXML is a great function, a real game changer.
See workbook here:
https://docs.google.com/spreadsheets/...
#FilterXML
#CombineMultiple
#Unique