Transpose with a merge

Mcaputo6

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?

Genevieve P.

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