Use a single survey entry to create multiple records in the same data table
I am looking to figure out a way I could possibly use a single survey entry to create multiple records in the same data table. For example, I have the following survey I am using to track the locations of assets moving from one location to another:
Naturally this data comes into a very concise table indicating how much of an asset has moved from one location to another location
ObjectID | Origin | Destination | Date | Quantity | Asset Year |
1 | 1234 | 5678 | 3/29/2020 19:00 | 10000 | 2020 |
2 | 5678 | 6789 | 3/30/2020 19:00 | 1000 | 2020 |
3 | 12 | 6543 | 3/30/2020 19:00 | 1200 | 2020 |
I'm looking for a way I can manipulate this survey such that the data is entered as 2 different records- one for the incoming location and one for the outgoing location? This way when we export this data it is easier to create a pivot table tallying the number of assets in each locations.
Does anyone have any ideas of how this could be accomplished? I feel like I could potentially accomplish using something like repeats but am struggling to wrap my head around how to get this result
| Transaction Number | Location | Date | Quantity | Asset Year |
| 1 | 1234 | 3/29/2020 19:00 | -10000 | 2020 |
| 1 | 5678 | 3/29/2020 19:00 | +10000 | 2020 |
| 2 | 5678 | 3/30/2020 19:00 | -1000 | 2020 |
| 2 | 6789 | 3/30/2020 19:00 | +1000 | 2020 |
