Hi everyone!
Here I have not clearly structured report, I have to convert in pivotable view. Like this:
Operation | Name | Characteristic name | Characteristics | Sum |
No.1 Ball Color red 5
Weight 2.5
Diameter 10
No.2 Cube Color green 2
Planes 6
No.3 Rectangle Color blue 1
In output table I want to see:
Operation| Name |Sum|Color |Weight| Diameter| Planes |
No.1 Ball 5 red 2.5 10
No.2 Cube 2 green 6
No.3 Rectangle 1 blue
I want to solve this problem by Power Query, but haven't enough skills..![Frown :( :(](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f641.png)
Have some thoughts about spliting input table in numerous tables (by quantity of characteristics names) and join them by "Operation", but can't handle with inexplicit number of characteristic names..
Thanks a lot and sorry for my English![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
Here I have not clearly structured report, I have to convert in pivotable view. Like this:
Operation | Name | Characteristic name | Characteristics | Sum |
No.1 Ball Color red 5
Weight 2.5
Diameter 10
No.2 Cube Color green 2
Planes 6
No.3 Rectangle Color blue 1
In output table I want to see:
Operation| Name |Sum|Color |Weight| Diameter| Planes |
No.1 Ball 5 red 2.5 10
No.2 Cube 2 green 6
No.3 Rectangle 1 blue
I want to solve this problem by Power Query, but haven't enough skills..
![Frown :( :(](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f641.png)
Have some thoughts about spliting input table in numerous tables (by quantity of characteristics names) and join them by "Operation", but can't handle with inexplicit number of characteristic names..
Thanks a lot and sorry for my English
![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)