How can I merge responses of two Google Form identical to each other but in two different languages

I want to combine the responses of two of my Google Forms that are identical to each other but in two different languages. How can I combine the responses to get the summary of both sets of responses?

9,983 30 30 gold badges 32 32 silver badges 50 50 bronze badges asked May 12, 2021 at 10:42 Mili Bridge Mili Bridge 11 1 1 silver badge 2 2 bronze badges

Consider sharing a publicly editable sample spreadsheet with realistic-looking data, and showing your hand-entered expected results there.

Commented May 12, 2021 at 17:44

Welcome to Web Applications. There are many ways to do that. What have you tried so far? Is this something that should be done only once or continuously? Are you already sending the form responses to an spreadsheet? How many questions and responses do your forms have or do you expect that they will have?

Commented May 13, 2021 at 1:53

1 Answer 1

You have two Google Forms. They are identical except that they are in different languages. You want a summary of the combined responses.

Use QUERY to create an array that combines the results of two separate queries - one for each Form Response sheet.

The query should be something like this:

The key aspects are:

create a query for each form
create an array using curly brackets
combine the queries between the curly brackets using a semicolon ( ; ) to combine/stack the output from each query
create your own column headers

Example

The query is in Cell A3

Combined

Responses - Form#1 (French)

form1

Responses - Form#2 (Maltese)