If column A has same column B, create new table that gives list of column A that had the same column

[Anonymous]

I suspect this may have to be done in powerquery

I currently have

a       b

1	x
1	y
2	x
2	z
3	z
3	w

and would like to create a new table that looks like this

1	2
2	1
2	3
3	2

I would appreciate any assistance on this, thanks.

[Anonymous · Accepted solution]

Hi @Anonymous ,

You can create a calculated column as below to get it, please find the details in the attachment.

Best Regards

[amitchandak]

@Anonymous , The value of 2 as 1 and 3 does not seem fine to me.

Group by in power query you can try

https://docs.microsoft.com/en-us/power-query/group-by