I'm looking at doing data entry connecting documents to land parcels.
Each document can apply to multiple parcels.
I would like to create a survey (for ease of data entry) and use a multivalue question associate the two, then unpivot it so I have a table to relate my list of documents and my list of parcels.
E.g.
Becomes
Is there an easy way to unpivot data?
If there is, can I set it up to happen automatically with each form that comes in? I understand that would probably end up making two different tables (Raw and Final), but I'm fine with that.
I also understand that Survey 123 is not necessarily the best program for this; if anyone has any suggestions for this, I'd happily take them. I know that you can unpivot in MS Access, for example. The goal is to be contributing to the table as new documents are created with minimal data entry instances.
Thanks!