How I automatically merged Students Firstname, Secondname, Last Name into Full Names via Power Query
If you frequently receive names in split form containing firstname, secondname and lastname and you want to automatically be merging them into one column then this is the video for you.
Steps
1.Select the Data
2.Convert the data into a table and load power query editor
3.Select the three columns
4. Rightclick and select Merge
5.Specify the separator and provide new column name
6.Close and Load the query back to excel