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

     

  • jz7ssr's avatar
    jz7ssr
    Regular Visitor
    7 years ago

    Thankyou!  This does it all in one click, I was trying to write a complicated looping routine.

    Perfect thanks.