Forum Discussion
Merging two tables into one new format
Hello all! I would like to ask for your help on a problem I am facing. I am trying to combine two tables together and generate a new format. I tried several times with some relationship but I ca...
Hi,
Output:
First you have to append the two tables to a new table.
Then create two custom columns to merge the data for GateA3/B1 and A5/B2.
Then unpivot the gates to create a gate column.
Find example Power BI file here:
https://1drv.ms/u/s!AjX6-gq4HfZQg_9lNcajVGumPNESoA?e=oBokFH