I have data being submitted by a form. When a new form is submitted, Zapier takes the data and creates a new row in an Excel spreadsheet. This is working as expected. However, I need assistance with the way the data is laid out.
For example, my form collections the follow:
- First Name
- Last Name
- Number of Requests? (1-8)
- Request 1 - Date
- Request 1 - Equipment
- Request 2 - Date
- Request 2 - Equipment
- Request 3 - Date
- Request 3 - Equipment
And this can continue on up to eight “date” and ‘equipment” sections based on the selection from “Number of Requests.”
When this form is submitted, it is linear, as is shown as:
| FN | LN | Request | R1 Date | R1 Equ | R2 Date | R2 Equ | R3 Date | R3 Equ |
|---|---|---|---|---|---|---|---|---|
| John | Doe | 3 | 7-25-22 | 40291 | 7-27-22 | 49291 | 7-27-22 | 49521 |
However, what I’d like to get to is Zapier taking the data and doing something like this:
| FN | LN | Date | Equ |
|---|---|---|---|
| John | Doe | 7-25-22 | 40291 |
| John | Doe | 7-27-22 | 49291 |
| John | Doe | 7-27-22 | 49521 |
Is there a way to accomplish this? I have yet to find a way.
