How to combine multiple data entries (rows) to a single row with additional collumns?

Megan J

Hello,

I am working towards combining data from multiple entries into a single row. An example of what I have is in the first Photo and what I need is in the second photo. So far, I have been able to make a sheet that identifies the list of unique row names (i.e. "1" and "2" ) I am having trouble now pulling the data entries ("A", "B", "C", "D"..) into separate columns of the unique row. Any help is greatly appreciated!

Thanks!

Sean Morgan

Hello @Megan J ,

How is this data entered into the Sheet? If its via a Form, you may wish to add additional Columns.

My assumption is that "1" and "2" would essentially be 2 different people, and to prevent them having 2 lines of data each, you would like the data the belongs to them consolidated to a singular row? Please let me know if I've misunderstood this.

If this my assumption is correct, I feel this may not be possible with the use of Formulas as if multiple rows of data are being added, the logic for a Formula may have issues directly targeting cells that have similar data.

Please let me know if I have misunderstood this

Kindest Regards

Sean