Transform columns into rows

[Zehava_Rubin]

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

[TheTimeSavingCo]

Try out doing this with an automation with 3 "Create record" actions

[Zehava_Rubin]

Can you be more specific? And is this the only way to do it.