Get Data - Folder Issue

[ThomasM]

Hi All

I am trying to read multiple files from a folder using the Get Data - Folder Selection.

These multiple files  all have column headings and the problem comes when the column headings become part of the data values.

Is there an option to ignore the column headings from second file until the last one?

Thanks,

Thomas

[BhaveshPatel · Accepted solution]

Hi @ThomasM

You can filter those values to remove the headers pulled out with each of your files.