Request help to reorganize data in Google Sheets

[Gilles]

What are you trying to achieve?

Hello,

I am requesting your help to reorganize values ​​located on the same row into two separate rows in Google Sheets.

Currently, each row contains the following fields in the current Google Sheets file:

“Last Name”
“First Name”
“Wife Last Name”
“Wife First Name”
I would like to reorganize this data in another Google Sheets file as follows:

Row 1: “Last Name : DUPONT”, “First Name : Gilles”
Row 2: “Last Name: DUPONT”, “First Name : Sophie”
I am attaching a screenshot to help you better visualize the situation.
Which module should I use?

Thank you in advance for your help!
Gilles

Screenshots: scenario setup, module configuration, errors

[momomomonmon]

@Gilles
Using Google Sheets “Get a Row” and “Add a Row” Modules, i think your question is solved.
You get name data from the current Google Sheets by “Get a Row” module.You add “Add a Row” module after “Get a Row” module, get input data from Get a Row module’s response.
reference: https://www.make.com/en/help/scenarios/creating-a-scenario#add-google-sheets---add-a-row-module

[Gilles]

Hello
I think I forgot to specify.
in fact, I wanted to retrieve this information from a single line to put it in each line, therefore in two lines
Here is my screenshot

Thanks you for your response
My Best regards
Gilles