Generate Part Number Configurations Using Power Query

Hi TessMissy ,

Thanks for posting your query in the Microsoft Fabric Community.  I tried your NAS1149 part number scenario in Power Query and found a solution that matches the format you need.

Please take a look and let me know if it works for you or if you want any changes.

FYI:

Used Code:

Table.AddColumn(#"Changed Type", "Custom", each Text.Combine(
    List.Select({
        Text.From([BasicPartNumber]),
        Text.From([MaterialCode]),
        Text.From([SizeCode]),
        Text.From([OversizeCode]),
        Text.From([FinishCode])
    }, each _ <> null and _ <> ""),
    " "
))

For future questions, it would be helpful if you could provide:

1. A sample of the input data in table format (not as screenshots)
2. An example of the desired output based on that input

This helps ensure we can support your request more accurately. If the solution works, marking it as accepted could also assist others with similar issues.