Forum Discussion
Pivot Table?
I have a table of four columns: height, length, width and number. I need to gather the data in a new table where all the instances with the same height, length and width are aggregated and where the ...
Savia Thank you. I tried that, but I get this "layout" back :
Is it possible to get a pivot table in the same format as the original table with four columns do you think?
camilla2312 Yes - Under the PivotTable options Design menu, change the Report Layout to Tabular, and switch off any subtotals.
Savia Thank you so much 🙂
camilla2312 You're welcome! Don't forget to mark my reply as the best solution; it will help future readers who find this thread 🙂