how to make multiple columns to become multiple rows

[Anonymous]

Hello! I have a table like this 

Id       opendate           call1start    call1end  call2 start   call2 end  call3 start   call3 end

001     20220830         14:00            14:02       14:30          14:32       null             null

some Ids have 2 calls, some have 3 calls, 4 calls, I hope the table can become
id    opendate    callstart      callend

001  20220830    14:00            14:02
001  20220830    14:30            14:32

002  20220903     15:00           15:24

please help me make it out! Thank you!

[v-zhangti · Accepted solution]

Hi, @Anonymous 

You can try the following methods. Make a copy of the original table in Power Query. Each table retains one callstart and callend, and the column names are changed to be consistent.

Append two table:

Result:

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Oh, you are so smart, and the method is very simple! Thanks a lot!