thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $69
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Data & Analytics · Intermediate

Unpivot Columns

A Power Query transformation that turns selected columns into attribute-value row pairs, converting wide data to long format.

Definition

Unpivot is essential when source spreadsheets have one column per month or year; 'Unpivot Other Columns' keeps working as new period columns appear. Tableau Prep and Tableau's data source pane offer pivot (columns to rows) for the same purpose.

Exam tip

Use 'Unpivot Other Columns' so new month columns are handled automatically.

Related terms