Remove meta-data above header row of CSV files when importing

[freelensia]

I have several CSV files saved in the same folder. I am trying to import them all at once.

The problem is that each CSV file has 9 rows of meta-data before the header row, like this:

So I cannot even parse the header rows correctly:

How do I programmatically remove 9 rows from each file before parsing?

ImkeF @v-juanli-msft @Nolock @Anonymous ?

Tks!

[ImkeF]

Hi @freelensia ,

easiest would be to add a column with this formula:

Table.Skip([ContentTbl], 9)

[freelensia]

Unfortunately that did not work, @ImkeF 

[ImkeF]

Oh I see, the first screenshot was taken from column [Content] and not from column [ContentTbl] - my bad. Please paste a pic from the first table of column [ContentTbl] instead, so I can adjust the code.