How to create another table to combined more than two column

[Kamaizziati]

Hi,

I have one table that have many data column. The data is direct query data from database.

I need to combined more than two column into one column data.

How can I create new table to combine the colums.

Thanks

[v-huizhn-msft]

Hi @Kamaizziati,

In direct model, we can't create a new table in Power BI desktop. Could you please share your sample data, and I will check if I can achieve it using Query Editor? It's hard to reproduce your scenario without sample table.

Best Regards,
Angelia

[Kamaizziati]

Hi @v-huizhn-msft,

Below is my data. I want to combined data ActType1, ActType11, ActType12 and so on.

Thanks

[v-huizhn-msft]

Hi @Kamaizziati,

In Query Editor, please select ActType1, ActType11, ActType12 and so on->click "unpivot columns" under Transfer one Home page, all the values in ActType1, ActType11, ActType12 columns will enter into one column. For example, I want to comebine Jobtitle and Department.



Best Regards,
Angelia

[Kamaizziati]

Hi @v-huizhn-msft,

I already do the uunpivot column but its change another data value that not include in the unpivot column.

[v-huizhn-msft]

Hi @Kamaizziati,

Have you resolved your issue? If you have, welcome to share your solution or mark the right reply as answer. More people will benefit from here.

Best Regards,
Angelia

[v-huizhn-msft]

Hi @Kamaizziati,

You mean other column's data has been changed? Yes, it does.  For your scenario, if you combine all columns to one. You create several tables likeTableA including A, B, C, ActType1, TableB including A, B, C, ActType2, TableB including A, B, C, ActType3. Then you can append them to one table. More details, please review this article.

Best Regards,
Angelia