Forum Discussion
Helper IIICreate Pivot table
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
Community Supporthi, 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
OSSv-lili6-msft Thank you very much. This is exactly what I was looking for.
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.
Month - Year Tot Avail Rented Vacated Net 12/1/2018 719955 31521 30450 1071 11/1/2018 707765 31244 31216 28 10/1/2018 728607 34848 34184 664 9/1/2018 713773 35320 35248 72 8/1/2018 695455 38134 43183 -5049 7/1/2018 687525 40915 33624 7291 I want it to look like this.
Month - Year 12/1/2018 11/1/2018 10/1/2018 9/1/2018 8/1/2018 7/1/2018 Tot Avail 719955 707765 728607 713773 695455 687525 Rented 31521 31244 34848 35320 38134 40915 Vacated 30450 31216 34184 35248 43183 33624 Net 1071 28 664 72 -5049 7291
