Column to row

[shadymedhat]

Hello fellows,

I have a table of 2 columns “unique code” and “email” ,so the case is that one code could have many emails, so i want show all emails for specific code at one row..


Thank U

 

[sandy666]

you can post an example of source data here with generic data

 

[shadymedhat]

How?

 

[sandy666]

read here: https://www.mrexcel.com/forum/about-board/508133-attachments.html#post2507729

 

[sandy666]

or you can try Power Query aka Get&Transform with this M-code:

[SIZE=1]let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Group = Table.Group(Source, {"unique code"}, {{"Count", each _, type table}}),
    List = Table.AddColumn(Group, "List", each List.Distinct(Table.Column([Count],"email"))),
    Extract = Table.TransformColumns(List, {"List", each Text.Combine(List.Transform(_, Text.From), ","), type text}),
    Split = Table.SplitColumn(Extract, "List", Splitter.SplitTextByAnyDelimiter({","}, QuoteStyle.Csv))
in
    Split[/SIZE]

 

[sandy666]

if you don't use Excel then ignore my posts above

 

[shadymedhat]

Could apply any of above , using excel

 

[sandy666]

what is your excel version?

 

[sandy666]

share excel file via OneDrive, GoogleDrive or any similar and post link to this file here

 

[shadymedhat]

https://www.dropbox.com/s/eko8dihi5mhl7eg/Column to Row 30 OCT 2019.png?dl=0