Create a band between two colums

Hi Valnus ,

You can easily get this done in Power Query Editor in Power BI Desktop.

Consider the following input data:

Select both the columns in the data above --> right-click --> merge columns

Once you hit merge columns, a new window appears. Give the relevant details as shown below and hit Ok.

You will get the required details:

In case you want this as an additional column to you existing 2 columns --> then make sure to duplicate your both columns first and then follow all the steps.