Numerous data collectors use multiple sections of a Google Form™ to submit data resulting in many rows for each unique participant. Merge it into one row using this add-on
Listing updated:August 31, 2024
Works with:
31
Overview
Imagine you're conducting a study where multiple data collectors are filling out the same Google Form™ for each participant. Each data collector might have a different section of the Google Form™ to fill out, but they all use a common identifier for each participant, like a participant ID. When all the inputs are collected into a Google Sheet™, you might end up with multiple rows for the same participant, each filled out by a different data collector.

This add-on helps you consolidate all that information into a single row for each participant. It does this by using the participant ID as a unique identifier. When you use the add-on, it asks you to specify which column contains the participant IDs or whatever identifier you give to your respondents. Then, it goes through each row in the sheet. If it finds a row with a participant ID that it hasn't seen before, it keeps that row. If it finds a row with a participant ID it has seen before, it merges the new information from that row with the information already collected for that participant. This way, you end up with a clean, consolidated list where each participant has only one row, containing all the information collected from all the different sections of the Google Form™.

This process is like having a big, messy pile of papers, each with a piece of the puzzle for a single participant. The add-on sorts through all those papers, putting each piece of the puzzle together into a single, complete picture for each participant. It's a way to organize and simplify the data, making it easier to analyze and understand.
Additional information
PricingFree of charge
Privacy policy
Terms of service
SkiVEMS-merge-rows-01 will ask for the permissions shown below. Learn more
SkiVEMS-merge-rows-01 will need access to your Google account
This will allow SkiVEMS-merge-rows-01 to :
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
KELVIN ANNOR-ADDAE
July 5, 2024
This really help in analyzing my research data. Thanks very much for this application. It has been very helpful
Is this review helpful?
Yes
No
Profile Picture
Emmanuel Wilson
May 19, 2024
This is a very very good tool. But the description in the marketplace does not mention you can combine 2 or more data in different sheets. I am particularly grateful for the support you give, my ability to get on a zoom call with support and talk me through the process while I combine all my tables from different sheets. Thanks very much for that. 10 sheets combined successfully. Pricing is great too, no subscriptions, I only have to purchase what I need, and thanks for giving back the merge times I wasted for free. This is a real time saver
Is this review helpful?
Yes
No
Profile Picture
Correspondent W
May 4, 2024
Great add-on. Very good you can determine how much you want to spend. Keep pricing as low as it is with alternate payment methods. Support is on time as well.
Is this review helpful?
Yes
No
Profile Picture
nanboltd
March 21, 2024
Great add on, my sales team, and supply team was able to collect data from customers at different times, using different sections of the form, and this really help merge the different rows together.
Is this review helpful?
Yes
No
Profile Picture
Butcherman Meats
March 21, 2024
this was very helpful
Is this review helpful?
Yes
No
1-5 of 5
Search
Clear search
Close search
Google apps
Main menu