How to prepare data for a Pivot Table
QuickRows is an Excel add-in that offers a simple solution for you to prepare your data for a Pivot Table, or any other method of analyzing your data.
It is common to find in Excel data tables that are in a “rebel” format, that is, that are not prepared for you to analyze them.
For example, you may have encountered values that are concatenated in the same column or numerical values that you cannot total, because they have an inadequate format.
If the data table has only a few rows, you can solve it “by hand” in a few minutes. It gets more complicated when it has hundreds or thousands of rows. In this case you would need a whole weekend to do it.
Excel is a powerful tool that offers you the means to solve these tasks (and many other similar ones) in a very effective way. But if you are reading this, it is because you probably don’t know the formulas or functions to solve them and you are looking for a quick solution.
Fortunately, QuickRows offers a simple solution for you to prepare (i.e clean and normalize) your data for a PivotTable, or any other method of analyzing your data.
Watch this short video and download the free trial version to see and experience how QuickRows works.