Unpivot Columns
Unpivot Columns is a table transformation available in the Power Query editor.
Contents
Usage
Given a table like the following in the Power Query editor:
id |
interaction1 |
interaction2 |
interaction3 |
1 |
10 |
15 |
17 |
2 |
10 |
12 |
null |
3 |
12 |
null |
null |
4 |
13 |
17 |
null |
The table can be transformed into a tall list of interactions by selecting the relevant columns and selecting Transform > Unpivot Columns. This modifies the table in-place into:
id |
Attribute |
Value |
1 |
interaction1 |
10 |
1 |
interaction2 |
15 |
1 |
interaction3 |
17 |
2 |
interaction1 |
10 |
2 |
interaction2 |
12 |
3 |
interaction1 |
12 |
4 |
interaction1 |
13 |
4 |
interaction2 |
17 |