Forum Discussion
ValeriaBreve
Post Partisan
Post PartisanLogic 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 em...
Hello, ValeriaBreve
Table.Skip(your_table, List.PositionOf(your_table[Column1], "ECC", Occurrence.First))
AlienSx
Super User
Super UserHello, ValeriaBreve
Table.Skip(your_table, List.PositionOf(your_table[Column1], "ECC", Occurrence.First))
ValeriaBreveworks like a charm! Thanks 🙂