Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Convert Data Entered as Column Entries to Row Entries

‎10-30-2020 01:40 PM

Hi.

I have been looking through the Search for a way to accomplish my desired format manipulation but I'm not sure that I'm using the appropriate terminology. Is it possible to perform the following data conversion when data is imported?


I would like to take data that is exported in this format;

Event IdRes TypeActionResponse Time
468745MAOnScene4/1/2020 5:29
468745MADeparted4/1/2020 5:31
468746TWOnScene4/1/2020 5:58
468746TWDeparted4/1/2020 6:53
468746PEnRoute4/1/2020 5:34
468746POnScene4/1/2020 5:37
468746PDeparted4/1/2020 6:53
468746FEnRoute4/1/2020 5:34
468746FOnScene4/1/2020 5:36
468746FDeparted4/1/2020 6:23
468746EEnRoute4/1/2020 5:34
468746EOnScene4/1/2020 5:37
468746EDeparted4/1/2020 6:23
468746MANotified4/1/2020 5:34
468746MAEnRoute4/1/2020 5:34
468746MAOnScene4/1/2020 5:40
468746MADeparted4/1/2020 5:41
468746MANotified4/1/2020 5:34
468746MAEnRoute4/1/2020 5:34
468746MAOnScene4/1/2020 5:41
468746MADeparted4/1/2020 6:53
468746TWOnScene4/1/2020 6:31
468746TWDeparted4/1/2020 6:53
468747MAOnScene4/1/2020 5:56
468747MADeparted4/1/2020 5:56
468748MAOnScene4/1/2020 6:00
468748MADeparted4/1/2020 6:02

 

So that it reads in this format;

EventIDResp1TypeResp1NotifiedResp1EnRouteResp1OnSceneResp1DepartedResp2TypeResp2NotifiedResp2EnRouteResp2OnSceneResp2DepartedResp3TypeResp3NotifiedResp3EnRouteResp3OnSceneResp3DepartedResp4TypeResp4NotifiedResp4EnRouteResp4OnSceneResp4DepartedResp5TypeResp5NotifiedResp5EnRouteResp5OnSceneResp5DepartedResp6TypeResp6NotifiedResp6EnRouteResp6OnSceneResp6DepartedResp7TypeResp7NotifiedResp7EnRouteResp7OnSceneResp7Departed
468745MA  4/1/2020 5:294/1/2020 5:31                              
468746TW  4/1/2020 5:584/1/2020 6:53P 4/1/2020 5:344/1/2020 5:374/1/2020 6:53F 4/1/2020 5:344/1/2020 5:364/1/2020 6:23E 4/1/2020 5:344/1/2020 5:374/1/2020 6:23MA4/1/2020 5:344/1/2020 5:344/1/2020 5:404/1/2020 5:41MA4/1/2020 5:344/1/2020 5:344/1/2020 5:414/1/2020 6:53TW  4/1/2020 6:314/1/2020 6:53
468747MA  4/1/2020 5:564/1/2020 5:56                              
468748MA  4/1/2020 6:004/1/2020 6:02                              
Labels:
Message 1 of 20
1,432 Views
0
1 ACCEPTED SOLUTION
camargos88
Community Champion
Community Champion

‎11-05-2020 08:15 AM

@Anonymous ,

 

Based on the Excel example, I've removed the Responder Id column.

Try this new m code:

 

let
    Source = Csv.Document(File.Contents("D:\Downloads\Book2.csv"),[Delimiter=",", Columns=6, Encoding=1252, QuoteStyle=QuoteStyle.None]),
    #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
    #"Filtered Rows" = Table.SelectRows(#"Promoted Headers", each ([Event Id] <> "")),
    #"Removed Columns" = Table.RemoveColumns(#"Filtered Rows",{"Responder Id"}),
    #"Changed Type" = Table.TransformColumnTypes(#"Removed Columns",{{"Event Id", Int64.Type}, {"Responder Type", type text}, {"Name", type text}, {"Action", type text}, {"Response Time", type datetime}}),
    #"Grouped Rows" = Table.Group(#"Changed Type", {"Event Id", "Action"}, {{"Rows", each Table.AddIndexColumn(_, "Index", 1,1), type table}}),
    #"Removed Other Columns" = Table.SelectColumns(#"Grouped Rows",{"Rows"}),
    #"Expanded Rows" = Table.ExpandTableColumn(#"Removed Other Columns", "Rows", {"Event Id", "Responder Type", "Name", "Action", "Response Time", "Index", "Res Type"}, {"Event Id",  "Responder Type", "Name", "Action", "Response Time", "Index", "Res Type"}),
    #"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Expanded Rows", {"Event Id", "Name", "Action", "Response Time", "Index"}, "Item", "Value"),
    #"Unpivoted Columns1" = Table.UnpivotOtherColumns(#"Unpivoted Columns", {"Event Id", "Action", "Response Time", "Index", "Item", "Value"}, "Attribute", "Value.1"),
    #"Duplicated Column" = Table.DuplicateColumn(#"Unpivoted Columns1", "Index", "Index - Copy"),
    #"Duplicated Column1" = Table.DuplicateColumn(#"Duplicated Column", "Index", "Index - Copy.1"),
    #"Merged Columns" = Table.CombineColumns(Table.TransformColumnTypes(#"Duplicated Column1", {{"Index - Copy", type text}}, "pt-BR"),{"Item", "Index - Copy"},Combiner.CombineTextByDelimiter("_", QuoteStyle.None),"Item"),
    #"Merged Columns1" = Table.CombineColumns(Table.TransformColumnTypes(#"Merged Columns", {{"Index", type text}}, "pt-BR"),{"Action", "Index"},Combiner.CombineTextByDelimiter("_", QuoteStyle.None),"Action.1"),
    #"Merged Columns2" = Table.CombineColumns(Table.TransformColumnTypes(#"Merged Columns1", {{"Index - Copy.1", type text}}, "pt-BR"),{"Attribute", "Index - Copy.1"},Combiner.CombineTextByDelimiter("_", QuoteStyle.None),"Name"),
    Union = 
        Table.Combine({
                Table.RenameColumns(Table.SelectColumns(#"Merged Columns2", {"Event Id", "Response Time", "Action.1"}), {{"Response Time", "Value"}, {"Action.1", "Item"}}),
                Table.Distinct(Table.SelectColumns(#"Merged Columns2", {"Event Id", "Item", "Value"}), {"Event Id", "Item"}),
                Table.Distinct(Table.RenameColumns(Table.SelectColumns(#"Merged Columns2", {"Event Id", "Name", "Value.1"}), {{"Name", "Item"}, {"Value.1", "Value"}}), {"Event Id", "Item"})
        
        }),
    #"Pivoted Column" = Table.Pivot(Union, List.Distinct(Union[Item]), "Item", "Value")
in
   #"Pivoted Column"

 



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



View solution in original post

Message 18 of 20
1,217 Views
19 REPLIES 19
camargos88
Community Champion
Community Champion

‎11-05-2020 08:54 AM

@Anonymous ,

 

I'm happy it worked!!!



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



Message 20 of 20
1,137 Views
0
camargos88
Community Champion
Community Champion

‎11-05-2020 08:15 AM

@Anonymous ,

 

Based on the Excel example, I've removed the Responder Id column.

Try this new m code:

 

let
    Source = Csv.Document(File.Contents("D:\Downloads\Book2.csv"),[Delimiter=",", Columns=6, Encoding=1252, QuoteStyle=QuoteStyle.None]),
    #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
    #"Filtered Rows" = Table.SelectRows(#"Promoted Headers", each ([Event Id] <> "")),
    #"Removed Columns" = Table.RemoveColumns(#"Filtered Rows",{"Responder Id"}),
    #"Changed Type" = Table.TransformColumnTypes(#"Removed Columns",{{"Event Id", Int64.Type}, {"Responder Type", type text}, {"Name", type text}, {"Action", type text}, {"Response Time", type datetime}}),
    #"Grouped Rows" = Table.Group(#"Changed Type", {"Event Id", "Action"}, {{"Rows", each Table.AddIndexColumn(_, "Index", 1,1), type table}}),
    #"Removed Other Columns" = Table.SelectColumns(#"Grouped Rows",{"Rows"}),
    #"Expanded Rows" = Table.ExpandTableColumn(#"Removed Other Columns", "Rows", {"Event Id", "Responder Type", "Name", "Action", "Response Time", "Index", "Res Type"}, {"Event Id",  "Responder Type", "Name", "Action", "Response Time", "Index", "Res Type"}),
    #"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Expanded Rows", {"Event Id", "Name", "Action", "Response Time", "Index"}, "Item", "Value"),
    #"Unpivoted Columns1" = Table.UnpivotOtherColumns(#"Unpivoted Columns", {"Event Id", "Action", "Response Time", "Index", "Item", "Value"}, "Attribute", "Value.1"),
    #"Duplicated Column" = Table.DuplicateColumn(#"Unpivoted Columns1", "Index", "Index - Copy"),
    #"Duplicated Column1" = Table.DuplicateColumn(#"Duplicated Column", "Index", "Index - Copy.1"),
    #"Merged Columns" = Table.CombineColumns(Table.TransformColumnTypes(#"Duplicated Column1", {{"Index - Copy", type text}}, "pt-BR"),{"Item", "Index - Copy"},Combiner.CombineTextByDelimiter("_", QuoteStyle.None),"Item"),
    #"Merged Columns1" = Table.CombineColumns(Table.TransformColumnTypes(#"Merged Columns", {{"Index", type text}}, "pt-BR"),{"Action", "Index"},Combiner.CombineTextByDelimiter("_", QuoteStyle.None),"Action.1"),
    #"Merged Columns2" = Table.CombineColumns(Table.TransformColumnTypes(#"Merged Columns1", {{"Index - Copy.1", type text}}, "pt-BR"),{"Attribute", "Index - Copy.1"},Combiner.CombineTextByDelimiter("_", QuoteStyle.None),"Name"),
    Union = 
        Table.Combine({
                Table.RenameColumns(Table.SelectColumns(#"Merged Columns2", {"Event Id", "Response Time", "Action.1"}), {{"Response Time", "Value"}, {"Action.1", "Item"}}),
                Table.Distinct(Table.SelectColumns(#"Merged Columns2", {"Event Id", "Item", "Value"}), {"Event Id", "Item"}),
                Table.Distinct(Table.RenameColumns(Table.SelectColumns(#"Merged Columns2", {"Event Id", "Name", "Value.1"}), {{"Name", "Item"}, {"Value.1", "Value"}}), {"Event Id", "Item"})
        
        }),
    #"Pivoted Column" = Table.Pivot(Union, List.Distinct(Union[Item]), "Item", "Value")
in
   #"Pivoted Column"

 



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



Message 18 of 20
1,218 Views
Anonymous
Not applicable
In response to camargos88

‎11-05-2020 08:39 AM

Wow that was quick. This is awesome! Exactly what I was looking for and works great on other raw files. I can't thank you enough for being patient and taking the time to work with me.

Message 19 of 20
1,141 Views
camargos88
Community Champion
Community Champion

‎11-05-2020 08:05 AM

@Anonymous ,

 

That's because you have different values on Respond Id and Name for the Event Id 468738.



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



Message 16 of 20
1,148 Views
0
Anonymous
Not applicable
In response to camargos88

‎11-05-2020 08:11 AM

Yeah I see what you're saying. I was hoping to get those on one row. You've done so much to this point I hate to ask too much more. I really appreciate all your help.

Message 17 of 20
1,146 Views
0
camargos88
Community Champion
Community Champion

‎11-04-2020 01:40 PM

@Anonymous ,

 

I got this result, only changing the source:

Capture.PNG



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



Message 14 of 20
1,171 Views
0
Anonymous
Not applicable
In response to camargos88

‎11-05-2020 07:24 AM

I am able to get it to work using the Raw Format file but when I attempt to change the source to the following file, Book2.csv, it doesn't produce the same results. I'm getting multiple row entries for Event Id 468738.

 

Here are the raw files and resulting formated file.

https://www.dropbox.com/s/4sgvdica6731m5e/Book2%20Final%20Format.zip?dl=0

 

 

sltraffic_1-1604589727668.png

 

 

Message 15 of 20
1,153 Views
0
camargos88
Community Champion
Community Champion

‎11-04-2020 01:22 PM

@Anonymous ,

 

I'm not sure if it's the result you want:

let
    Source = Csv.Document(File.Contents("D:\Downloads\responders2.csv"),[Delimiter=",", Columns=6, Encoding=1252, QuoteStyle=QuoteStyle.None]),
    #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Event Id", Int64.Type}, {"Responder Id", Int64.Type}, {"Responder Type", type text}, {"Name", type text}, {"Action", type text}, {"Response Time", type datetime}}),
    #"Grouped Rows" = Table.Group(#"Changed Type", {"Event Id", "Action"}, {{"Rows", each Table.AddIndexColumn(_, "Index", 1,1), type table}}),
    #"Removed Other Columns" = Table.SelectColumns(#"Grouped Rows",{"Rows"}),
    #"Expanded Rows" = Table.ExpandTableColumn(#"Removed Other Columns", "Rows", {"Event Id", "Responder Id", "Responder Type", "Name", "Action", "Response Time", "Index", "Res Type"}, {"Event Id", "Responder Id", "Responder Type", "Name", "Action", "Response Time", "Index", "Res Type"}),
    #"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Expanded Rows", {"Event Id", "Responder Id", "Name", "Action", "Response Time", "Index"}, "Item", "Value"),
    #"Duplicated Column" = Table.DuplicateColumn(#"Unpivoted Columns", "Index", "Index - Copy"),
    #"Merged Columns" = Table.CombineColumns(Table.TransformColumnTypes(#"Duplicated Column", {{"Index - Copy", type text}}, "pt-BR"),{"Item", "Index - Copy"},Combiner.CombineTextByDelimiter("_", QuoteStyle.None),"Item"),
    #"Merged Columns1" = Table.CombineColumns(Table.TransformColumnTypes(#"Merged Columns", {{"Index", type text}}, "pt-BR"),{"Action", "Index"},Combiner.CombineTextByDelimiter("_", QuoteStyle.None),"Action.1"),
    Union = 
        Table.Combine({
                Table.RenameColumns(Table.SelectColumns(#"Merged Columns1", {"Event Id", "Responder Id", "Name", "Response Time", "Action.1"}), {{"Response Time", "Value"}, {"Action.1", "Item"}}),
                Table.Distinct(Table.SelectColumns(#"Merged Columns1", {"Event Id", "Responder Id", "Name", "Item", "Value"}), {"Event Id", "Item"})
        
        }),
    #"Pivoted Column" = Table.Pivot(Union, List.Distinct(Union[Item]), "Item", "Value")
in
   #"Pivoted Column"

 

Just change the path in the beginning:

Source = Csv.Document(File.Contents("D:\Downloads\responders2.csv"),[Delimiter=",", Columns=6, Encoding=1252, QuoteStyle=QuoteStyle.None]),



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



Message 12 of 20
1,173 Views
0
Anonymous
Not applicable
In response to camargos88

‎11-04-2020 01:35 PM

The previous version was closer. Here is a link to the raw file and the final format desired.

https://www.dropbox.com/s/qp4g4xsim5yfh8r/Example.zip?dl=0

 

Message 13 of 20
1,172 Views
0
camargos88
Community Champion
Community Champion

‎11-04-2020 11:57 AM

@Anonymous ,

 

I don't have this option. However paste this code on Edit Queries -> New Source -> Blank Query:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("xZNPC4IwGIe/iuwsOOc2zVvQhA79wYQO4iFsgYem5Ar69q06lPpqu3WYjO3x97y6d3mOxE0q7SyPyEWpbJ3s3kgznZe6qtV7ralVK52sOktUuDmiPAopM1uruXls1K6U6vkK9XyPYIIdFpMZQC5kc7hoeeyigf9BudnK9mOhLAJIKJTHLOiiWzOESuur7mUGdAiC8iAcgnbuxNadjLr5EITdpOcWtm5h+93C2v0683Wtq1M1OHMKoFZ1jrccxQAJtxz1/1sppLfrpbHLweFr9Ds0nKyUcYCE/+k3Gk2E8hhjgIQrxQQVxQM=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"(blank)" = _t, #"(blank).1" = _t, #"(blank).2" = _t, #"(blank).3" = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"(blank)", type text}, {"(blank).1", type text}, {"(blank).2", type text}, {"(blank).3", type text}}),
    #"Promoted Headers" = Table.PromoteHeaders(#"Changed Type", [PromoteAllScalars=true]),
    #"Changed Type1" = Table.TransformColumnTypes(#"Promoted Headers",{{"Event Id", Int64.Type}, {"Res Type", type text}, {"Action", type text}, {"Response Time", type datetime}}),
    #"Grouped Rows" = Table.Group(#"Changed Type1", {"Event Id", "Action"}, {{"Rows", each Table.AddIndexColumn(_, "Index", 1,1), type table}}),
    #"Removed Other Columns" = Table.SelectColumns(#"Grouped Rows",{"Rows"}),
    #"Expanded Rows" = Table.ExpandTableColumn(#"Removed Other Columns", "Rows", {"Event Id", "Res Type", "Action", "Response Time", "Index"}, {"Event Id", "Res Type", "Action", "Response Time", "Index"}),
    #"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Expanded Rows", {"Event Id", "Action", "Response Time", "Index"}, "Attribute", "Value"),
    #"Duplicated Column" = Table.DuplicateColumn(#"Unpivoted Columns", "Index", "Index - Copy"),
    #"Merged Columns" = Table.CombineColumns(Table.TransformColumnTypes(#"Duplicated Column", {{"Index - Copy", type text}}, "pt-BR"),{"Attribute", "Index - Copy"},Combiner.CombineTextByDelimiter("_", QuoteStyle.None),"RespType"),
    #"Merged Columns1" = Table.CombineColumns(Table.TransformColumnTypes(#"Merged Columns", {{"Index", type text}}, "pt-BR"),{"Action", "Index"},Combiner.CombineTextByDelimiter("_", QuoteStyle.None),"Action.1"),
    Union = 
        Table.Combine({
                Table.RenameColumns(Table.SelectColumns(#"Merged Columns1", {"Event Id", "Response Time", "Action.1"}), {{"Response Time", "Value"}, {"Action.1", "Item"}}),
                Table.Distinct(Table.RenameColumns(Table.SelectColumns(#"Merged Columns1", {"Event Id", "RespType", "Value"}), {{"RespType", "Item"}}), {"Event Id", "Item"})
        
        }),
    #"Pivoted Column" = Table.Pivot(Union, List.Distinct(Union[Item]), "Item", "Value")
in
    #"Pivoted Column"


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



Message 10 of 20
1,169 Views
0
Anonymous
Not applicable
In response to camargos88

‎11-04-2020 12:43 PM

That's awesome...you are a Super User! That worked exactly how I envisioned.

 

Only problem, and it's not something that you provided. I want to apply it to my actual raw data file but it contains more columns than I provided. I thought I would be able to expand it but the code is more complicated than I imagined. What would the code be for this format and where in the Steps would I copy/paste it? This file has been reduced to what will end up being a single row with the corresponding entries. Here's a dropbox link to the file.

https://www.dropbox.com/s/3shkz9p481vx57r/responders2.csv?dl=0

 

If this is asking too much feel free to say so...I would completely understand.

Message 11 of 20
1,178 Views
0
Anonymous
Not applicable

‎11-04-2020 11:55 AM

Would it be possible to save this version down to the 2.78 (Feb 2020) version. I have to go through my Admin to update to the newest version and it's likely to take a while to accomplish?

Message 9 of 20
1,170 Views
0
camargos88
Community Champion
Community Champion

‎11-04-2020 11:24 AM

@Anonymous ,

 

Check the attached file.

 

 



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



sltraffic2.pbix
Message 8 of 20
1,175 Views
0
camargos88
Community Champion
Community Champion

‎11-04-2020 07:39 AM

@Anonymous ,

 

Which visualization are you trying to achieve ?

I'm asking it because you may have problems with some calculations when you get this model.



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



Message 6 of 20
1,182 Views
0
Anonymous
Not applicable
In response to camargos88

‎11-04-2020 10:41 AM

I'm not entirely sure. I was waiting to see if I could format my database in the manner I've mentioned. Bar chart showing the total MA entries to start and then see what other options I can develop.

Message 7 of 20
1,177 Views
0
camargos88
Community Champion
Community Champion

‎10-30-2020 02:26 PM

Hi @Anonymous ,

 

Check the attached file:

Capture.PNG



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



sltraffic.pbix
Message 2 of 20
1,301 Views
Anonymous
Not applicable
In response to camargos88

‎11-03-2020 02:34 PM

Thank you for the suggestion, unfortunately, this isn't exactly what I was wanting to do. I want to take the raw data as multiple row entries and convert it to a single row entry.

 

Any other suggestions?

Message 3 of 20
1,217 Views
0
camargos88
Community Champion
Community Champion
In response to Anonymous

‎11-03-2020 03:00 PM

@Anonymous ,

 

I am sorry, I didn't get what you need, can you explain it more ? Example with data would be great.



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



Message 4 of 20
1,213 Views
0
Anonymous
Not applicable
In response to camargos88

‎11-03-2020 03:11 PM

Absolutely. Hope this helps.

 

My raw data is exported in a vertical fashion where 1 Event ID will be entered into a row followed by the Res Type, Action, and Response time. So using Event ID 468745 has the 1st entry where the Action is OnScene and Response Time then a 2nd entry when the Action is Departed and Respone Time. Instead of having mulitple rows, I'd like to automatically change the format to the 2nd table where I have 1 row entry with the corresponding Res Type, Action, Respnose Time as Colunns.

Event IdRes TypeActionResponse Time
468745MAOnScene4/1/2020 5:29
468745MADeparted4/1/2020 5:31
468746TWOnScene4/1/2020 5:58
468746TWDeparted4/1/2020 6:53
468746PEnRoute4/1/2020 5:34
468746POnScene4/1/2020 5:37
468746PDeparted4/1/2020 6:53
468746FEnRoute4/1/2020 5:34
468746FOnScene4/1/2020 5:36
468746FDeparted4/1/2020 6:23
468746EEnRoute4/1/2020 5:34
468746EOnScene4/1/2020 5:37
468746EDeparted4/1/2020 6:23
468746MANotified4/1/2020 5:34
468746MAEnRoute4/1/2020 5:34
468746MAOnScene4/1/2020 5:40
468746MADeparted4/1/2020 5:41
468746MANotified4/1/2020 5:34
468746MAEnRoute4/1/2020 5:34
468746MAOnScene4/1/2020 5:41
468746MADeparted4/1/2020 6:53
468746TWOnScene4/1/2020 6:31
468746TWDeparted4/1/2020 6:53
468747MAOnScene4/1/2020 5:56
468747MADeparted4/1/2020 5:56
468748MAOnScene4/1/2020 6:00
468748MADeparted4/1/2020 6:02

 

In this table I have the multiple row entries converted to 1 row entry with column headings representing the row entries. Using Event ID 468746 as an example, I have multiple Response Types, multiple entries of OnScene and Departed, etc. that I'm hoping to convert to this table format.

EventIDResp1TypeResp1NotifiedResp1EnRouteResp1OnSceneResp1DepartedResp2TypeResp2NotifiedResp2EnRouteResp2OnSceneResp2DepartedResp3TypeResp3NotifiedResp3EnRouteResp3OnSceneResp3DepartedResp4TypeResp4NotifiedResp4EnRouteResp4OnSceneResp4DepartedResp5TypeResp5NotifiedResp5EnRouteResp5OnSceneResp5DepartedResp6TypeResp6NotifiedResp6EnRouteResp6OnSceneResp6DepartedResp7TypeResp7NotifiedResp7EnRouteResp7OnSceneResp7Departed
468745MA  4/1/2020 5:294/1/2020 5:31                              
468746TW  4/1/2020 5:584/1/2020 6:53P 4/1/2020 5:344/1/2020 5:374/1/2020 6:53F 4/1/2020 5:344/1/2020 5:364/1/2020 6:23E 4/1/2020 5:344/1/2020 5:374/1/2020 6:23MA4/1/2020 5:344/1/2020 5:344/1/2020 5:404/1/2020 5:41MA4/1/2020 5:344/1/2020 5:344/1/2020 5:414/1/2020 6:53TW  4/1/2020 6:314/1/2020 6:53
468747MA  4/1/2020 5:564/1/2020 5:56                              
468748MA  4/1/2020 6:004/1/2020 6:02                              
Message 5 of 20
1,211 Views
0

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

View All