Transpose and combine multiple csv files in excel power query

the original question and code found here

Transpose and combine multiple csv files in excel power query
Transpose and combine multiple csv files in excel power query
Transpose and combine multiple csv files in excel power query

Transpose,powerquery,excel,combine,many csv,multiple csv,query,power query,spectral data,