Create Pivot table

---

v-lili6-msft wrote:

hi, OSS 

Do mean that the three columns are from different table and you haven't put them into one table like this:

If so you need to put them into one table, use Merge queries function in edit query to merge basic tables and then remove the other columns to get a table that contains these three columns.

then pivot the table as below:

Select Origin column click Transform -> Pivot column

Result:

 

Best Regards,

Lin

 

 

 

 

---

How do I do this for a table with more than one column?

I have a table like this.

I want it to look like this.