How to transform table using Power Query

Power Query
1

Hi, Everyone,

I have a bit of challenge with Power Query to transform table into certain format to do Venn-diagram analysis. I believe it has been covered somewhere, but I am not how to find the topic.

Basically, I have a table with the following format:
image

What I’d like to do is using Power Query to transform it to the format like this:
image

Could you please help with the steps and function to do the table transform in Query Editor?

Thanks a lot!

Mike

2

Hi ,

If you want the result like below:

image
image745×136 5.21 KB

I also attached the pbix which contain the solution :
EDNA.pbix (23.8 KB)

Let me know incase my above provided solution does not solve your problem.

Thanks,
Anurag

2 Likes
3

Hi, @Anurag

That is exactly what I was looking for. I tried to use Pivot or Unpivot, but did not know it can be achieved by Group function.

Thanks!

Mike

4

Mike, this video is a great help with transforming data:

Transpose, pivot or unpivot in Power Query? - YouTube