The beauty of Pivot tables in Excel is, you can always change the report layout quickly by dragging different fields to placeholders to create different combinations.
Tag: microsoft excel
‘Transpose’ to change the alignment of cell contents in Microsoft Excel
Imagine you made a sales report in Microsoft Excel vertically and now you are requested to show the opposite way in columns horizontally. Do you feel like wasted so many hours doing the report? And again, you have to spend a few more hours to prepare the expected report. Neither re-do nor moving cells here […]
