I used Power Query/Get and Transform found on the Data Tab of the Ribbon to get your expected results.
Here is the Mcode from those steps
Excel 2016 (Windows) 32 bit
|
Q |
R |
S |
T |
U |
V |
W |
25 |
Attribute.1 |
CV |
MT |
FR |
OT |
FS |
GT |
26 |
Product A |
16.66666667 |
16.85393258 |
|
|
17.24137931 |
17.04545455 |
27 |
Product B |
|
22.22222222 |
23.52941176 |
22.72727273 |
|
|
28 |
Product C |
|
|
|
47.5 |
46.34146341 |
|
Review PQ
In the attached file
Click on any cell in the new table
On the Data Tab, click on Queries & Connections
In the right window, double click to open Query
Review PQ steps
M-code basics:
- "let" is the start of a query
- "in" is the closing of a query
- each transformation step sits in between those 2 lines
- each step line is ended by a comma, except the last one
- "Source" is always the first step (Source Data)
- After "in" you have the last step referenced
File attached
Bookmarks