How to Spread on Same row

Question
1

Hellos,

Currently when we spread items , original number of rows are maintained. For me , most of the times there is a small additional process to remove these rows with combo of Sort +Rank + Fill by Key+ Filter to remove duplicates .

See my example

forums_post.transform (4.1 KB)

  1. Is there a better way ?
  2. Future Request to flatten in same row with Spread + Flatten values in same rows
2

Can you do it in some combination of Spread and Unique.

forums_post2.transform (3.2 KB)

3

ooh , thanks , uniques solves it in 1 single click perfect :smiley:

1 Like