Text join ignoring blanks but limited to a maximum of five entries

Hello,
(edited for more clarity)
I need to a formula to join text in cells together ignoring blanks but stop at a maximum of 5 entries
I've tried textjoin, this works fine in joining all the cells but I only need a maximum of 5 entries.

For example using textjoin cell AP25 reads 6,8,9,13,15,18,19, but I only require the first 5 so i need it to read 6,8,9,13,15

Text to columns would work but it would be great if I could do this via a formula.
I need Column AQ to look as it is but by using a formula (I've typed the entries in)
Hope this makes sense.

Thanks for your help!!

Hi,

=LEFT(TEXTJOIN(REPT(" ",99)&CHAR(10),,W25:AO25),495)

Regards

Please try at AP4

=TEXTJOIN(CHAR(10),,IFERROR(SMALL(IF(C4:U4=0,$C$1:$U$1),SEQUENCE(5))&",",""))

** Correction for OP Last edited **
=TEXTJOIN(", ",,IFERROR(SMALL(IF(C4:U4=0,$C$1:$U$1),SEQUENCE(5)),""))

Hi thanks for your response I've edited the original post for more clarity.

Sequence function is available for Office 365 Monthly update.

For Office 365 non-Update version

=TEXTJOIN(", ",,IFERROR(SMALL(IF(C4:U4=0,$C$1:$U$1),{1,2,3,4,5}),""))


**Array formulas are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself).

Please try at Q5

=TEXTJOIN(", ",,IFERROR(INDEX($C$2:$M$2,SMALL(IF(C5:N5=0,$C$1:$N$1),{1,2,3,4,5})),""))

Confirm by Ctrl+Shift+Enter

Yes, Bo_Ry's formula should be:

=TEXTJOIN(", ",,IFERROR(INDEX($C$2:$N$2,N(IF(1,SMALL(IF(C5:N5=0,$C$1:$N$1),{1,2,3,4,5})))),""))

Regards