Power query editor question

[Anonymous]

Hey guys,

I have a table with number, designation and company, like:

Number	Designation	Comp
11	Retreats	IJ
11	Retreats	UI
1101	Event 1	IJ
1101	Event 1	UI

I would like to have it ike this:

Number	Designation	Comp A	Comp B
11	Retreats	IJ
11	Retreats		UI
1101	Event 1	IJ
1101	Event 1		UI

 I've tried grouping, unpivot or pivot and so far nothing.

Any ideas?

Thank you very much

Pedro

[v-juanli-msft · Accepted solution]

Hi @Anonymous

Add a conditional column

Pivot column

Best Regrads

Maggie

[Anonymous]

Guys,

Correction. The final output would b like this:

Number	Designation	Comp A	Comp B
11	Retreats	IJ	UI
1101	Event 1	IJ	UI
1102	Event 2	IJ	UI

Thanks