How to Wrap 2 Columns at the same time?

[Lacan]

Hello Guys,

Have this "ORIGINAL" table as a result of a filter function.
Despite the number of the rows below (because maybe have to adjust them in the future) how is the formula to get the "END RESULTS" example?
All the help is welcome!!!
Thank you very much!!!

Fórmula Principal para o Ficheiro VDF.xlsm
	A	B	C	D	E	F	G	H	I	J
1
2
3			ORIGINAL			END RESULTS
4			CUSTOMER	POTENCIAL
5			APPLE	D10		APPLE	D10	SANTA	D05
6			XPTO	D08		XPTO	D08	CCM	D04
7			AUCHAN	D06		AUCHAN	D06	RDAM	D03
8			WORTEN	D07		WORTEN	D07	GOUSE	D02
9			SANTA	D05
10			CCM	D04
11			RDAM	D03
12			GOUSE	D02
13
14
29-09-2024

 

[Fluff]

If you always want 6 rows max try

=LET(s,SORT(C5#,2,-1),IF(ROWS(s)>6,IFNA(HSTACK(TAKE(s,6),DROP(s,6)),""),s))

 

[Lacan]

Thank you very much @Fluff
Worked very well!!!

 

[Fluff]

You're welcome & thanks for the feedback.