Forum Discussion

jz7ssr's avatar
jz7ssr
Regular Visitor
7 years ago
Solved

Looping through table to create another one

Hi, I'm have a table which has been setup as follows:   PostCode CompanyA CompanyB CompanyC CompanyD 3015 Yes Yes No No 3016 No Yes No Yes 3017 No Yes Yes Yes 3018 N...
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, jz7ssr

    You can use Unpovit Function in Edit Queries and then filter Value is Yes as below:

    Step1:

    Select Column CompanyA, CompanyB, CompanyC, CompanyD then click Unpovit Columns


    Step2:

    Filter the Value is "Yes"

    Result:

     

    Best Regards,

    Lin

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
7 years ago

Yes, in Power Query, select your PostalCode column, right-click in select Unpivot other columns.