Possible to "Skip fist Lines" with Google Sheet?

[scottb]

I fear the answer is “no,” but worth asking!

I have a google sheet with 6 rows of “instructions” for folks who will be remediating the data, and the actual column headers are on row 7. If this were a standard file, I would just use the option to skip the first 6 rows. The closest thing I can see to this with the Google Sheets reader is the ability to specify the range, but I won’t know the size of the data table; just that it starts on row 7.

Am I missing anything, or does anybody have any clever workarounds for this one?

Thanks!

[scottb]

I think I figured this out. I read the entire spreadsheet without any row or column headers, used a row filter to get rid of the first 6 rows, and then I used this solution:

Promote a Row to be a Column Name

Hi team, I have a workflow very complicated, I’m working on it, but now I have the column names in the second row after use transpose node, so, how can I promote this row to be a column names [image] Thanks in advance!!!

To get my column names in place.