CSV to clear merged cells in Excel
Someone recently had a huge challenge. He wanted to do analysis on a spreadsheet that was formatted for people to read. It wasn’t set up for data crunching.
When we try to sort or add a pivot table we learn that there are merged cells all throughout the document.
Save as CSV to destroy any and all formatting–merged cells, bold font, colors … everything!