Line Break after each unique entry

[garypea123]

Good Afternoon,

Unfortunately I do not have XLSBB on computer (due to restrictions)

In C4 I have my list of numbers

In D4 I would like a formula which will look at the data from C4# and create a break after each unique entry.

Have a great weekend all

 

[garypea123]

Unfortunately, still getting a #NAME?

​

 

[Fluff]

Forgot to remove the two Drop functions, try

=LET(u,UNIQUE(C4:C12),rd,REDUCE("",u,LAMBDA(a,b,LET(f,FILTER(C4:C12,C4:C12=b),r,ROWS(a),s,SEQUENCE(r+ROWS(f)+1),IFERROR(IF(s<=r,a,INDEX(f,s-r)),"")))),INDEX(rd,SEQUENCE(ROWS(rd)-2,,2)))

 

[garypea123]

That works absolutely perfect - Thank you very much for your assistance

 

[Fluff]

Glad we could help & thanks for the feedback.