Unpivoting Columns - some cloumn's title need kept, some not,

[Yubo]

Hello Everyone,

I want to unpivot table with 5 columns to a new table with 2 cloumns as below. 

The 1st cloumn title need to be kept in table 2.

the 2nd abd 3rd cloumn title not need in the new table, instead of, need the contents in the new table.

Please help. 

Many thanks!!

[amitchandak · Accepted solution]

Power Query has split and merge options.

In dax you can try like

union(
summarize(table,table[Date_s],"Action","Date_s"),
summarize(table,table[Date 2],table[Type1 1]),
summarize(table,table[Date 3],table[Type1 2])
)

Not sure how you have same column name date 2 , twice

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin

[Yubo]

Hi Super User IV,
Sorry for bothering again. The table 2 (I learn from you) is created, now I have table 3 (actually, it is query, Tried in query edit, can’t merger query and table together) need to combine Table 2 and table 3 in one final table, Please help if possible. Many thanks for your help!!

Many thanks !!

[Yubo]

Hi amitchandak,

It works perfectly. ( it is a typo, should be Date 3)

thank you very much!!! 😊