Same site find the diferent tecnologies

[wolfy_]

Hi all,

Does any one know how to shaping the values of Tecn. of one column for a new colum whit all the Tecnologies fot that SITE

The new colum is Tecnologies, does any one know hot to get it?

SITE	Tecn.	Tecnologies
SITE_A	2G	2G_3G_4G
SITE_A	3G	2G_3G_4G
SITE_A	4G	2G_3G_4G
SITE_B	3G	3G
SITE_C	2G	2G_3G
SITE_C	3G	2G_3G
SITE_D	2G	2G_3G_4G_5G
SITE_D	3G	2G_3G_4G_5G
SITE_D	4G	2G_3G_4G_5G
SITE_D	5G	2G_3G_4G_5G

[Ashish_Mathur]

Hi,

This M code works

let
    Source = Excel.CurrentWorkbook(){[Name="Data"]}[Content],
    #"Grouped Rows" = Table.Group(Source, {"SITE"}, {{"All Technologies", each Text.Combine([#"Tecn."]
,","), type text}, {"All", each _, type table [SITE=text, #"Tecn."=text]}}),
    #"Expanded All" = Table.ExpandTableColumn(#"Grouped Rows", "All", {"Tecn."}, {"Tecn."}),
    #"Reordered Columns" = Table.ReorderColumns(#"Expanded All",{"SITE", "Tecn.", "All Technologies"})
in
    #"Reordered Columns"

Hope this helps.

[v-shex-msft · Accepted solution]

HI @wolfy_,

IF you mean to concatenate the 'Tecn' field values based on site group, I'd like to suggest you add a calculated column with concatenatex function.

Tecnologies =
CONCATENATEX ( FILTER ( Table, [SITE] = EARLIER ( Table[SITE] ) ), [Tecn.], "_" )

Regards,

Xiaoxin Sheng