Forum Discussion
Post PartisanHelp with virtual tables
Hi ValeriaBreve ,
I would prefer that you use power query to achieve this result.
Copy the po1 table and pivot the Rank field of this table,like this screenshot
result:
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Post PartisanHi, thanks, however the idea is not to create another table.
I need to filter the existing Table1 for the rank I need and add a column to the existing Table2 per rank. This is why I would like to use a virtual table, not to multiply Table 2 filtered for each rank.However, once I filter Table2 creating a virtual table, I need to lookup the PO and to do that I need column names which I don't know how to get from virtual table....