Merging data from different file into single sheet

[neeraj2050]

Greetings!!

I have several excel files with same formatting and columns in use

I have to get them merged i.e into single file and single sheet, data from entire file get arranged one after another.

Is there any suggestion?

Thanks in advance!!

Regards
Neeraj Kumar Agarwal

 

[Hui]

This is a fairly common question with a number of different answers

Please use the Search Box at the top of this and every page at Chandoo.org

 

[pecoflyer]

Search the net for Rondebruin...

 

[NARAYANK991]

Hi ,

See if this helps :

https://msdn.microsoft.com/en-us/library/cc837974(v=office.12).aspx

Narayan

 

[Hui]

also
https://support.office.com/en-us/article/Power-Query-Combine-Binaries-94b8023c-2e66-4f6b-8c78-6a00041c90e4