To merge multiple CSV files into one

[dudebauaa]

If we have multiple CSV files, having two columns and more than 50 rows. The first column in all the files is identical (having some parameters in row) and in second column there are corresponding values (which may be different in each CSV files).

By using cmd option and Power query, in the file is combined row wise, while i want .. the merged file should have only the first column of first file, and second column of all the remaining files in next columns. So that we can use the data in proper manner.

Thanks in advance if anyone can help on this

 

[alansidman]

Can you provide some sample data so that we can test and provide a viable Mcode solution. Use XL2BB to upload your sample data and then a mocked up solution. 8-10 records should suffice as an example.