Рет қаралды 151
To design a pivot table, you should:
Use clean, tabular data for best results.
Organize your data in columns, not rows.
Make sure all columns have headers, with a single row of unique, non-blank labels for each column.
Avoid double rows of headers or merged cells.
Format your data as an Excel table (select anywhere in your data, and then select Insert Table from the ribbon).