Forum Discussion
Merging three different files using Power Query in Power BI
My task is to fully automate procurement dashboard. The procurement team gets 3 excel files which contains only one common column. All other columns are different. In 1st excel - Purchase Doc., and i...
Hi hari27pn "same column but slightly different headings" did you try to rename columns to be the same in different tables and AFTER that merge as you need? Hope this help
No I wish to create a new table with the help of 3 excel files. I dont want to rename them as they are different columns. I want to merge the files sideways not downwards like we do Vlookup in Excel.