Generate Configurations using Power Query

[TessMissy]

Good evening,
I am requesting advice to generate a list of various part number configurations using PQ and display these part numbers in an Excel spreadsheet. In particular, I am attempting to generate a list of NAS1149 standard washer part number configurations using the data in the attached pdf file 'NAS1149'. I am new to PQ and have attempted to develop a list; my attempt is shown in the tab 'Output' in the attached spreadsheet. The part number configurations follow the particular order shown in the example below:



If someone could share their knowledge and expertise to develop the most efficient method to achieve this I would be most appreciative. Thank you.

 

[GraH - Guido]

Maybe these few tips can help:
- PQ remembers the order of selection (CTRL + Left Mouse CLICK) of columns
- Select merge columns from the UI Transformation tab and use space as delimiter
- In the same tab, look for Format and add prefix (to add doc number as it looks to be fixed value?)

The formula =Excel.Workbook() in a blank query, returns all the tables from your Excel.
Reference query allows you to build other queries from this starting point.
This might allow you do generate the table without having to use the parameter.