Forum Discussion

netanel's avatar
netanel
Post Prodigy
3 years ago
Solved

Group reorganization

I have two columns that come from the system product and sub-product I want to organize and arrange a product so that it includes more sub-product I know the answer is in Query but I can't find i...
  • netanel's avatar
    netanel
    3 years ago

    SergioSilvaPT 

    Yes, I thought about it, but I don't want to add Excel, because it needs constant maintenance and updating according to changes

     

    I found a solution!
    I multiply the sheet in Query and create a reference between the columns I want
    So they will be updated every time from the system
    But in the sheet I duplicated I create the updated groups according to what I want

    work like magic (:

     

    Thanks for your help!