i want to combine 55 excel files with same header and same footer.
while combining the together using power query, 55 header and footer are also combining.
how to avoid this as i dont want the header and footer to be there in the combined sheet.
how can it be done.!