I would like to create a Pivot to neaten my data but do not know Excel too well. Is there an easy way within Alchemex to create a Pivot?
Yes, you can use an Alchemex add-in to quickly create a Pivot.
Method
Run your report, in Excel select the Add-ins tab on the Ribbon, and in the Report Tools group select Quick Pivot.
The Quick Pivot Wizard will open, make your selections, it will automatically select sheet1 as Source Sheet.
Select the Format tab for any changes
Selecting any of the 3 color boxes in the Format window will open the Color window:
Make any necessary changes and click OK.
Click OK and Close
You now have a quick Pivot with only a few clicks:
