If your data is not previously in a very table, then format it to be a table. This will mechanically incorporate a filter button at the best of every table column. I discovered a fresh macro that promised to automate a particularly troublesome endeavor, conserve me a lot of time https://www.customguide.com/excel/concatenate-excel