For the last few versions of Excel, the standard pivot table format is to have all of the Row fields displayed in one column. But if you want to split your row fields into separate columns, you can switch to the “classic” pivot table view from earlier versions of Excel. Right-click on the Read More …
Month: March 2017
Merging multiple files with Power Query
A common problem in businesses is having several versions of the same spreadsheet being used by multiple different people making it difficult to combine them for any centralised reporting. It can be done using VB, but not particularly easily, but then Power Query came along and made this a quite simple step-by-step process. There are Read More …