I'm trying to create a pivot table from an external data source I copied into excel, however the important columns, "Address" and "Name", I need to analyze has a 'merged cells' error for some reason and is not letting me pull it into the pivot table. The cells don't appear merged and I have highlighted them to unmerge them without any success. I'm beyond frustrated, so any help you can provide would be great!
Solved by I. E. in 28 mins