Power QueryExercises

Turn attribute–value rows into one row per record (feedback)

A form tool stores answers as (RecordID, Field, Value) rows. Pivot Field so each record becomes one row.

Level
intermediate
Time
~8 min
Task
Build the query
Access
Pro
Checking your access…

About this exercise

What you'll practise

Pivot without aggregation when each key/field pair is unique.

The scenario, sample data, step list, hints and solution open with Pro. Grading checks your query against hidden data as well as the visible sample, so a query that only fits the sample doesn't pass.

Input

  • Answers (table)
    • RecordID: text
    • Field: text
    • Value: text

Expected output columns

RecordID (text), Rating (text), Session (text), Comment (text)