Merge Column

[jason81]

Hi All,
I am new into PowerBI and want to merge multiple rows into one row based on some values.

I found similar post but using advance editor.

http://community.powerbi.com/t5/Desktop/how-to-merge-multiple-rows-into-one-row-with-different-colum...

Does anyone able to solve this problem via step by step query editor methods?

Thank you!

FYI,

For example:

Raw data

Vendor	E-Mail Address
10000128	marie@dyne.com
10000128	xavier@dyne.com
10000588	Michael@tech.com
10000588	George@tech.com
10000588	salina@tech.com
10000622	PARRYJON@uk.com
10000622	coleem@uk.com
10000622	lowppi@sg.com

To be applicable by team:

VENDOR	EMAIL
10000128	marie@dyne.com; xavier@dyne.com;
10000588	Michael@Tech.com; George@tech.com; salina.chen@tech.com;
10000622	PARRYJON@uk.com; coleem@uk.com; lowppi@sg.com;

[Salonic · Accepted solution]

Hello,

You can create a new Measure (no column) with this formula :

Mails = CONCATENATEX(Vendor;Vendor[E-Mail Address];"; ") 

This will not create a new column in your table