Combining many csv files with the same headers

[ECB]

Hi there,

I hope you are well.

I've what I think is a relatively straightforward problem to solve. I have a number of csv output dumps that reside in a folder on my onedrive. They all have the exact same header row - nr, date, address, name etc

There's 77 files. All I want to do is merge the files into one big dataset, maybe around 6000 lines in total.

Now I now I can copy and paste each file in, but is there a quicker way?

Anyone any suggestions, or can point me to a solution? I'm sure this isn't something that someone hasn't done before.

All the best,
B

 

[AlanY]

have a look if power query works for you

 

[ECB]

have a look if power query works for you

That's great thanks - I think it will.

Because I'm on a Mac I don't think it will work because power query seems to be crippled. However, before I even fired up my windows partition I discovered that I can use a command line thingy in terminal so I got there.

Thanks for the taking the time to reply.

ATB
B

 

[AlanY]

That's great thanks - I think it will.

Because I'm on a Mac I don't think it will work because power query seems to be crippled. However, before I even fired up my windows partition I discovered that I can use a command line thingy in terminal so I got there.

Thanks for the taking the time to reply.

ATB
B

good luck for that.

 

[ECB]

good luck for that.

Scares the life out of me - but it worked in seconds!