Power Query - Collect File Attributes from Dynamic List of File Paths

[johnny51981]

I have a list of File Network Paths that I am needing to get into the attributes of those files. I am looking to (some how) use this list of FilePathNames and pull the Attributes from the actual file so I can start bringing the contents from all of the listed files and create one master list of data.

Any thoughts?

 

[alansidman]

Cannot manipulate data in a picture. Please upload your sample data using XL2BB and also show your expected results mocked up for the sample provided.

 

[johnny51981]

I'm not able to use xlbb due to company equipment restrictions.

But we had to go a different direction with this anyway due to other settings that are in place within my company's tech set up.

Thank you for your reply.