Hi, I have a table in airtables that has the following columns
1.persons first 2. last name and 3. regular hours worked 4. overtime hours worked 5. hazard hours worked.
I would like to transform the different type of hours worked columns into individual rows per person
so for example I am starting with the following
| First Name | Last name | Regular hours | overtime hours | hazard hours |
| sara | brum | 40 | 4 | 10 |
and I want to transform it to the following
| First name | Last name | amount | type |
| sara | brum | 40 | regular hours |
| sara | brum | 4 | overtime hours |
| sara | brum | 10 | hazard hours |
How can this be done? When I finish I would like to be able to export the data in this format or send it to a third party like zapier
