In Power Query, you can merge multiple columns into a single one. This is what we are going to do in this lesson.
Import a CSV file and create a table
Navigate to Data >> Get & Transform Data >> From Text/CSV.
Inside the next window, you have two options: Load and Transform Data.
![](https://officetuts.net/excel/wp-content/uploads/sites/2/2019/05/import-file.png)
If you click Transform Data, you can modify a table before placing it into a worksheet. But we will insert the data first, and then we are going to merge columns. Click the Load button.
Merge Columns
Now, we have a table inside a worksheet.
![](https://officetuts.net/excel/wp-content/uploads/sites/2/2019/05/table.png)
Click the table and navigate to Data >> Get & Transform Data >> From Table/Range.
Now, when we have a Power Query Editor opened you click First Name and (while holding Ctrl) the Last Name.
![](https://officetuts.net/excel/wp-content/uploads/sites/2/2019/05/power-query-editor-1.png)
Navigate to Transform >> Text Column >> Merge Columns.
In the next window, you have merge options. You can choose a separator between the merged columns, and a new name for the new column.
Let’s use space as a separator and Name as the name for the column.
![](https://officetuts.net/excel/wp-content/uploads/sites/2/2019/05/merged-columns.png)
If you try to close the Power Query Editor, a new message will pop up.
![](https://officetuts.net/excel/wp-content/uploads/sites/2/2019/05/keep-changes.png)
Press Keep to apply changes.
![](https://officetuts.net/excel/wp-content/uploads/sites/2/2019/05/table-applied-changes.png)
As you can see the table columns merged into one.