List.Transform Excel table different column combine not Working.

[RAKESH1986]

Hi ,

Could you help me, why this code is not working?

I have seen one video, it works fine in this video but not in my code. what wrong am I doing?

https://www.youtube.com/watch?v=09tvia_8ykI

I want to combine multiple excel sheets, having a different dynamic columns. 

[RAKESH1986 · Accepted solution]

its working by this change

= List.Transform(PreExpand[#"Transform File (2)"],each Table.ColumnNames(_))