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

 

[HighAndWilder]

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

Does this formula work?

Copy range from string until reach another string.xlsm
	C	D	E	F	G	H	I
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		APPLE	D10	SANTA	D05
12	GOUSE	D02		XPTO	D08	CCM	D04
13				AUCHAN	D06	RDAM	D03
14				WORTEN	D07	GOUSE	D02
Sheet296

Cell Formulas
Range	Formula
F11:I14	F11	=HSTACK(CHOOSECOLS(WRAPCOLS($C$5:$C$12,4),1),CHOOSECOLS(WRAPCOLS($D$5:$D$12,4),1),CHOOSECOLS(WRAPCOLS($C$5:$C$12,4),2),CHOOSECOLS(WRAPCOLS($D$5:$D$12,4),2))
Dynamic array formulas.

 

[Fluff]

Two other options

Fluff.xlsm
	A	B	C	D	E	F	G	H	I
1
2
3			ORIGINAL			END RESULTS
4			CUSTOMER	POTENCIAL
5			APPLE	D10		APPLE	D10	XPTO	D08
6			XPTO	D08		AUCHAN	D06	WORTEN	D07
7			AUCHAN	D06		SANTA	D05	CCM	D04
8			WORTEN	D07		RDAM	D03	GOUSE	D02
9			SANTA	D05
10			CCM	D04		APPLE	D10	SANTA	D05
11			RDAM	D03		XPTO	D08	CCM	D04
12			GOUSE	D02		AUCHAN	D06	RDAM	D03
13						WORTEN	D07	GOUSE	D02
Data

Cell Formulas
Range	Formula
C5:D12	C5	=N5:O12
F5:I8	F5	=WRAPROWS(TOCOL(C5#),4,"")
F10:I13	F10	=LET(r,CEILING.MATH(ROWS(C5#)/2,1),IFNA(HSTACK(TAKE(C5#,r),DROP(C5#,r)),""))
Dynamic array formulas.

 

[Lacan]

Two other options

Fluff.xlsm
	A	B	C	D	E	F	G	H	I
1
2
3			ORIGINAL			END RESULTS
4			CUSTOMER	POTENCIAL
5			APPLE	D10		APPLE	D10	XPTO	D08
6			XPTO	D08		AUCHAN	D06	WORTEN	D07
7			AUCHAN	D06		SANTA	D05	CCM	D04
8			WORTEN	D07		RDAM	D03	GOUSE	D02
9			SANTA	D05
10			CCM	D04		APPLE	D10	SANTA	D05
11			RDAM	D03		XPTO	D08	CCM	D04
12			GOUSE	D02		AUCHAN	D06	RDAM	D03
13						WORTEN	D07	GOUSE	D02
Data

Cell Formulas
Range	Formula
C5:D12	C5	=N5:O12
F5:I8	F5	=WRAPROWS(TOCOL(C5#),4,"")
F10:I13	F10	=LET(r,CEILING.MATH(ROWS(C5#)/2,1),IFNA(HSTACK(TAKE(C5#,r),DROP(C5#,r)),""))
Dynamic array formulas.

Dear @Fluff

Hope you are ok.
Thanks for the help.

However can you please add to your formula (=WRAPROWS(TOCOL(C5#),4,"") the sort function, column 2, descending order, by column not by lin (example below)?
Thank you very much!!!

 

[Fluff]

How about

=LET(s,SORT(C5#,2,-1),r,CEILING.MATH(ROWS(s)/2,1),IFNA(HSTACK(TAKE(s,r),DROP(s,r)),""))

 

[Lacan]

How about

=LET(s,SORT(C5#,2,-1),r,CEILING.MATH(ROWS(s)/2,1),IFNA(HSTACK(TAKE(s,r),DROP(s,r)),""))

It works well @Fluff

After some tests would like to change the number of rows apperance in 1st column, maybe it coul be 5 or 6 rows and the rest of results in 2nd column.
Is formula able to provide that so can make change accordingly?
Thank you very much!!

 

[Fluff]

How about

=LET(s,SORT(C5#,2,-1),IFNA(HSTACK(TAKE(s,5),DROP(s,5)),""))

 

[Lacan]

Dear @Fluff

Thanks for the help!
Through the previous formula there was data that didn't appear.
Think we are very near.
Let me clarify better through 3 sequences examples and son on.
Can you please check?
Again, thank you very much.

Through the update formula let´s suppose would like to changing in some function in formula to "1":
The number chosen should return the total rows in 1st column and the rest of data in the 2nd column.

Let´s suppose change in some function there to "3":

Let´s suppose change in some function there to "5":

And so on...

 

[Fluff]

As you keep moving the goal posts, can you please explain EXACTLY what you want.

 

[Lacan]

As you keep moving the goal posts, can you please explain EXACTLY what you want.

Dear @Fluff

After test it and re-test it think I´m in conditions to explain even better.
My original table with 8 rows is just a simple example because in my job worksheet will have more and different tables each one can have between 4 and 16 rows.
So if table has more then 6 rows here the example below

and if table has less then 6 rows they should stay in 1st column like:

Hope you can help.
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		APPLE	D10	ACP	D03
6	XPTO	D08	XPTO	D08		XPTO	D08	GOUSE	D02
7	AUCHAN	D06	AUCHAN	D06		AUCHAN	D06
8	WORTEN	D07	WORTEN	D07		WORTEN	D07
9	SANTA	D05	SANTA	D05		SANTA	D05
10	CCM	D04	CCM	D04		CCM	D04
11	ACP	D03	ACP	D03
12	GOUSE	D02	GOUSE	D02
13
14
29-09-2024 (2)

Cell Formulas
Range	Formula
C5:D12	C5	=UNIQUE(APPLE)
Dynamic array formulas.

Named Ranges
Name	Refers To	Cells
'29-09-2024 (2)'!APPLE	='29-09-2024 (2)'!$A$5:$B$12	C5