I had tried to upload the Export Detail BI file but even zipped at 2.5 MB it will not upload, so I will try to describe how to apply the Power Query based solution:
1. Select a cell in Table_1 on the D sheet
2. From the Data tab select From Table/Range
3. In the Power Query Editor select Advanced Editor and replace the code with the following:
4. Select Done
5. Select Close and Load to then Connection only and then OK
6. Repeat steps 1 and 2
7. Replace the Advanced Editor code with:
8. Repeat steps 4 and 5
9. From the Data tab select Get Data then From Other Sources and then Blank Query
10. In the Power Query Editor select Advanced Editor and replace the code with the following:
11. Select Done
12. Select Close and Load to and then OK (as Table and New Sheet should already be selected)
13. Type MAWB in cell F1 and the #'s in F2 and down
14. Paste the following into cell G2 then drag across to H2 and then down as far as needed:
15. Paste the following into cell I2 and drag down as far as needed:
16. Paste the following into cell J2 and drag down as far as needed:
17. Paste the following into cell K2 then drag down as far as needed and then drag across until there is a blank column:
Note that the range of columns in step 17 may have to be extended across further then column O and if so the formula in step 16 will need to be adjusted accordingly.
Let us know if you have any questions.
Bookmarks