WHAT IS PIVOT AND UNPIVOT?

Awadhendra Tiwari

Total Post:510

Points:2550
Posted by  Awadhendra Tiwari
 3554  View(s)
Ratings:
Rate this:
  1. Awadhendra Tiwari

    Post:510

    Points:2550
    What is PIVOT and UNPIVOT?

    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.

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!