Forum Discussion

Yoan_Tufel's avatar
Yoan_Tufel
Copper Contributor
May 18, 2022

Change data structure

Hello, I will try to be clear sorry if am not   Have I data that is structure like such: COLUMN A            B 1:phone        |  customer info 2: email         | custumer info 3: phone       | ...
BI & Data Analysis
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
May 18, 2022

Yoan_Tufel 

Power Query could work:

Script is

let
    Source = Excel.CurrentWorkbook(){[Name="data"]}[Content],
    #"Grouped Rows" = Table.Group(Source, {"Column1"}, {{"Info", each _[Column2]}}),
    Custom1 = Table.FromColumns(#"Grouped Rows"[Info], #"Grouped Rows"[Column1])
in
    Custom1
  • Yoan_Tufel's avatar
    Yoan_Tufel
    Copper Contributor
    May 18, 2022

    i will try as soon as possible

    SergeiBaklan 

Resources