Flatten the rows based on common id

[Shee_powerbi]

Hi, I am trying to create a table based on roles that employee has as per the excel file. Eg - 

Emp EmailID	Emp ID	Market	Region	Country	Area
adfer@xwes.com	WERQW	WGER		SW	ERL
dwer@xwes.com	WERFQ		ERLA	BZ	EWD
dwer@xwes.com	WERFQ	WDER		AU
werd@xwes.com	WERDQ	EDER	ERNA	NY	ERZ

Power Bi data

Emp ID	Market	Region	Country	Area
WERQW	WGER	EWDF	SW	ERL
WERFQ	WQSD	ERLA	BZ	EWD
WERFQ	WDER	ERFG	AU	EGH
WERDQ	EDER	ERNA	NY	ERZ
WERDQ	EWTH	ERNO	NJ	ERS

I need to match the employee roles in excel with those in power bi and create a table in power bi to add RLS using email id in the report. How do i flatten the table. Please help. 

[v-xiaotang]

Hi  @Shee_powerbi 

>> to create a table based on roles

it is not clear, please provide the expected output in table format, thanks

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.