Combining Columns on Sheet from Form
I am working on an audit stock sheet, that allows a form staff can utilize for active counts and confirm physical location. With this I am trying to find the function to combine rows with the same Product Name, Product ID, but have the differentiator being the room it is stored in. See screen shot:
With the newest submission I would like to have the function combine row 507 and 508, as they would have the Same Product name ID, and room while combining all information.
I was look into functions of:
=JOIN([Product Name]@row:[ID]@row, ", ") but I am stuck from here, any insight will help!
Help Article Resources
Check out the Formula Handbook template!