Forum Discussion
Combine multiple files with dynamic headers
Hi, I have a multiple sheets in which the headers at are at 2 subsequent rows: ie I want to compile these sheets such that this will be the resulting query *Data shown above ar...
=Table.Combine(List.Transform(YourTableList,each Table.RenameColumns(_,List.RemoveMatchingItems(List.Zip({Table.ColumnNames(_),Record.ToList(_{0})}),true,each if _ is logical then _ else _{0}=null or _{0}=""))))