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


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!



  • 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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!