At the time of writing (January 2025), TRIMRANGE doesn't allow you to trim blank rows or columns between existing data. You can only use it to trim data before or after your data.

Select the columns you want to fix. In this case we’re selecting the header columns — those at the very top of the ...

You can combine two columns in Excel using several formulas and tools available in the software. Here's how to combine two columns in Excel.