This has probably been asked before though I am not quite sure how to describe it in order ot actually find it in searches! I have a big stack of Excel files with roughly the same column template (I can deal with that) but the dat starts on different rows. Some of them have a single blank row before the headers and some of them have a blank row and a merged row (which I am not interested in keeping) first. The question is: is there a good way to consolidate Excel spreadsheets from one folder if the headers are on slightly different rows? Perhaps a variable to force it to only read a given row down to the end? Thanks for the input in advance :slight_smile:

Read files in folder - different row structures

gonhaddock November 7, 2022, 10:33am 7

Hello @JWebb
You could use @takbb 's workflow “Find Header Row For Excel”.

I did a modification based in previous workflow, that fits the excel once read; then you don’t need to read the file twice. You can nest this workflow in a loop…

1 Like