Combine Form Row information into Single Row data
We are looking for a way to take rows entered via webform and then merge the information into a single row of data.
To give you an example of what we are doing. We enter a building Number (currently Primary Column) and a unit number into the form. There are then unique items we are checking off in the form or entering notes etc. Not an issue if only one person is doing the entire entry, but since this is for 100% unit inspections we typically have more than one and up to four people entering different information.
Currently what we get from this is up to 4 rows of information for a single unit. How can we automate a process to take these rows and combine them based on the building number then the unit number? Would like to add information into a column from all 4 entries potentially without having it overwrite any one cell.