Forum Discussion
how to make multiple columns to become multiple rows
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!
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.
2 Replies
v-zhangtiCommunity Support
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.