Can anyone let me know which is the easiest and fastest way to "clean" (eliminate empty rows, columns, and total rows) a extensive financial report extracted from an accounting system using Excel so it can be use as source data for Pivot tables?
Your input is appreciated!!
Your input is appreciated!!