Hi, Currently sitting a pretty difficult task of combining dynamic and static data through an index number. I can explain more in a short call. If you’re good at excel, this task should not need more than 30min.
Basically I need to set up the sheets so i get master data from a form response, department sheets then pull this data and have to enrich them with manually entered data. Those rows shall not move when new data is entered or filtered out.
This is the core problem I am in front of: https://support.google.com/docs/thread/95901649/solving-the-dynamic-static-data-alignment-challenge-using-alignment-index-numbers?hl=en