I have a form designed to send to end users of printing devices in an office to collect data on how they use their devices. Nothing is previously known about the devices or users.
I want to then take that data and combine any entries that have the same serial number into 1 row of data.
The Serial number is part of the data collection.
If the data column is of checkbox type, where the serial numbers are duplicate, I want it to compare each cell in that column for only matching serial numbers and return a check if any single cell from all those cells has a check already, if they are all unchecked I would want it to remain unchecked. Essentially if any one person needs this feature then it gets recorded regardless of the other answers.
If the data column is a text entry, where the serial numbers are duplicate, I want it to combine those cells into one cell with a separator between each entry. (except my fax column)
Essentially I want to take data that looks like this:
And get it to look like this:
Without manual intervention.
Is this possible?
