Transpose with a merge

Mcaputo6
Mcaputo6
edited 01/19/24 in Add Ons and Integrations

I have the following data set:

A 1

A 2

A 3

B 10

B 20

B 30

B 40

C 10

I want to get it to be

A 1 2 3

B 10 20 30

C 10


How to accomplish this in smartsheets when the number of items for each group are different?

Answers

  • Hi @MCaputo

    Are you looking to have this in a separate sheet? Are the letters going down a column, and the numbers going down a different column?

    If so, in that second sheet you can use a formula to JOIN together multiple values based on an identifier:

    =JOIN(COLLECT({Number Column Reference}, {Letter Column Reference}, [Letter Column]@row), ", ")

    Here's more information: Formula combinations for cross sheet references

    Cheers,

    Genevieve

    Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.