Hey guys, So i have a pivot table, and i need to copy it to another page to run calculations on it and what not. when i copy it over, there are a lot of blank cells under the cells with content, since it was merged in a pivot table. I'm trying to create a macro which would automatically fill the...