Forum Discussion
Solved
Value checking - Multiple reasons in same cell (for errors/duplicates)
Hello, I need help with Power Query. I have 2 excel files. First with a list of skills and Second with list of users. These users come with a specific skills which I need to compare according to ...
Hi
Group and use Text.Combine
Table.Group(
Table2,
{"Email", "Name", "Country", "skill", "working from", "comment"},
{{"Rejection reason", each Text.Combine(List.Distinct([Rejection reason]),", "), type text}}
)Stéphane
Hi
Group and use Text.Combine
Table.Group(
Table2,
{"Email", "Name", "Country", "skill", "working from", "comment"},
{{"Rejection reason", each Text.Combine(List.Distinct([Rejection reason]),", "), type text}}
)
Stéphane