Forum Discussion
Import Query - Sample File from Folder doesn't read data
Hi I have a folder with excel files that have multiple sheets in them which holds the same data table structure and I need to consolidate them. I approach this as I do with normally - get data > f...
Anonymous
I guess you use the button in Content column? If so, add a custom column instead, combine the tables in Custom column. Let me know if it is not the case.
Hi there I have done as you mentioned and expanded the custom column. This was good for filtering all the sheets I need. Brillant!
I am use to expanding the Content header and using the sample file to clean up data... so mynext road block is how would i remove rows which are headers and where files meet like so:
Hi Anonymous
Can you promote the header before combining them? If you filter down to the tables/sheets you need, then promote header first...assume your headers are all the same for all the tables/sheets you want to combine
Or you can filter out the header later