Showing Posts From
merged cells

Excel Filter Only Shows the First Row of a Merged Group? Unmerge and Fill Down First
Your filter isn't broken, and you don't need to unmerge everything by hand and retype the missing labels. Fix the file before you filter: run the XLSX through the Unmerge & Fill tool, pick the two merged columns, and download a copy where every row carries its own team and date. Then filter and piv…