Need help with tables in Power Query

[AlertMtl]

Needing some help combining columns in power query that either contains table data or "Null". These are laser cut files that I need to extract attributes from ex. material, thickness and so on. There seem to be two formats, attached are 2 files opened in notepad, for these files (close to 15K). I will attach a screenshot of where I'm at in Power query. I was able to make a sample file for each format but unsure what to do from here.

 

[AlertMtl]

My appologies, all PN's are caps so keyboard stays that way...I may be screaming but def not at you haha. Added 4 more files, thank you

 

[sandy666]

Hope in your files are two formats only, so try this one

s666-PQ-AlertMtl_v2.xlsx

Microsoft Excel Workbook

1drv.ms