Hi @sr12 ,
You can import the data into power bi and merge it through power query.
Create some data:
1. Enter power query through transform data.
2. Select the column you want to merge, right-click the mouse, and select Merge Columns.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.