image-6 Use the Power Query Editor to merge columns together. Choose the columns you are interested in and then right click so that you can concatenate the columns.