Splitting rows to separate values

[Anonymous]

Hi! I have "Change Impacts" that have have 2 columns with infotmation. One is "E2E" and the other is "Type". Those columns can have more than one info, splited with a "," as yoy can see in the "Type" column.

 I need to create graphs counting each "Chane Impact ID" by "E2E" and "Type", incuding the values that are splitted by a ",". Any idea on how I could do it?

[ryan_mayu · Accepted solution]

@Anonymous 

what about split to rows?

https://learn.microsoft.com/en-us/power-query/split-columns-delimiter#split-columns-by-delimiter-into-rows?wt.mc_id=DP-MVP-5004616

then you can count each value separately.

[Ashish_Mathur · Accepted solution]

Hi,

In the Query Editor, split the contents of the Type column by rows using the comma delimiter.

[ryan_mayu · Accepted solution]

@Anonymous 

what about split to rows?

https://learn.microsoft.com/en-us/power-query/split-columns-delimiter#split-columns-by-delimiter-into-rows?wt.mc_id=DP-MVP-5004616

then you can count each value separately.