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	[email protected]
10000128	[email protected]
10000588	[email protected]
10000588	[email protected]
10000588	[email protected]
10000622	[email protected]
10000622	[email protected]
10000622	[email protected]

To be applicable by team:

VENDOR	EMAIL
10000128	[email protected]; [email protected];
10000588	[email protected]; [email protected]; [email protected];
10000622	[email protected]; [email protected]; [email protected];

[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