Forum Discussion

ValeriaBreve's avatar
ValeriaBreve
Post Partisan
3 years ago
Solved

Logic for removing top rows on a table

Hello,

I am trying to combine Excel files with data formatted in different ways.

In some of the files, columns start at row 4, in others at row 2, etc

 

Only the rows above the columns are not empty - there are annotations etc.

 

How can I skip the first N table rows until a criteria is met? For ex., in my case until the word "ECC" is found in the first column - that would be my first column header throughout all files.

 

Thanks!

Kind regards

Valeria

2 Replies