Forum Discussion
Grouping nested tables with different header names and column amounts
Hello, I am trying to figure out in Power Query how to group each "AB Failure Mode" listed below each "AB Failure Mode" instance in Column 1, as well as sum each similar column between each of the nested tables in accordance with the proper "AB Failure Mode". See image below of the table:
(I also don't need the PPM column, but I just planned to delete that column once everything is grouped)
Edited: I also don't need the Date column on the left, it just helped me with getting my data transformed to this point
| Custom | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 |
| 10/1/2023 | AB Failure Modes | ZP41K7E-TFD-333 | ZP61K5E-PFV-130 | TOTAL | PPM | |
| 10/1/2023 | Pressure Settle Timeout | 2 | 10 | 12 | 112 | |
| 10/1/2023 | Motor Starting Current | 15 | 1 | 16 | 55 | |
| 11/1/2023 | AB Failure Modes | ZP41K7E-TFD-333 | ZP61K5E-PFV-130 | YA14K1E-PFV-001 | TOTAL | PPM |
| 11/1/2023 | Pressure Settle Timeout | 2 | 10 | 1 | 12 | 112 |
| 11/1/2023 | Motor Starting Current | 15 | 1 | 1 | 16 | 55 |
| 11/1/2023 | Hipot failure | 2 | 1 | 1 | 1 | 4 |
| 12/1/2023 | AB Failure Modes | ZP41K7E-TFD-333 | ZP81K5E-PFV-130 | TOTAL | PPM | |
| 12/1/2023 | Pressure Settle Timeout | 2 | 10 | 12 | 112 | |
| 12/1/2023 | Motor Starting Current | 14 | 1 | 31 | 200 | |
| 12/1/2023 | Hipot failure | 2 | 10 | 16 | 13 |
1 Reply
Hi,
please post data not images in order to try to solve the problem
