How to merge data from multiple different forms into one row?
The process looks like this- 1 total data set with multiple teams entering data. Each team has a form specific to their metrics rather than the total data set. Each day, the different teams enter their own metrics and once everyone has entered, all the data is there... however... each new entry (on the same day) starts a new row. There are 6 different teams entering data, so the total data set ends up spanning over 6 separate rows daily. How can I ensure that all 6 forms (when entered on the same day) populate the same row?