Create rows from multiple columns (not a split)

[Syndicate_Admin]

I am trying find a way to transform the columns in a table to rows. (See below example). I need this in individual rows so I am able to build a Process Map with each row as a separate event in the overall process.

Master_id	Assist Id	Begin_Time	Dispatch_Time	End_Time	Technician
50001		7/25/2023 18:23	7/25/2023 18:30	7/25/2023 17:46	John Smith
50001	50002	7/25/2023 17:10	7/25/2023 17:16	7/25/2023 17:46	Nancy Miller

• Master id = Unique number assigned when call is generated (Begin Time show when this occurred)
• Dispatch Time = when the technician accepted the call.
• Assist id = Is assigned if the original technician request assistance with the call. (associated with the technician in that row.)
  • That dispatch time is shows when the assisting technician accepted the call.
• End Call = show when the call is completed.

Here is what I need the table to look like:

Master_id	Assist Id	Begin_Time	Dispatch_Time	End_Time	Technician
50001		7/25/2023 18:23			John Smith
50001			7/25/2023 18:30		John Smith
					John Smith
50001	50002	7/25/2023 17:10			Nancy Miller
50001	50002		7/25/2023 17:16		Nancy Miller
50001	50002			7/25/2023 17:46	Nancy Miller

[mussaenda · Accepted solution]

Hi @Syndicate_Admin ,

[lbendlin]

That seems to be a rather odd format for Power BI.  What are you planning to do with the result?