1.

What Is Pivot And Unpivot?

Answer»

A Pivot Table can AUTOMATICALLY sort, count, and total the data STORED in one table or spreadsheet and create a second table displaying the summarized data. The PIVOT operator TURNS the values of a specified column into column NAMES, effectively rotating a table.
UNPIVOT table is reverse of PIVOT Table.

A Pivot Table can automatically sort, count, and total the data stored in one table or spreadsheet and create a second table displaying the summarized data. The PIVOT operator turns the values of a specified column into column names, effectively rotating a table.
UNPIVOT table is reverse of PIVOT Table.



Discussion

No Comment Found