Filter column to add multiple cells into one cell

[PuntingJawa]

I'm trying to automate separation of lines with the filter function based on what number is in column B.
Example:
Filter if a cell in Column B has number 1 then return the adjacent cell in column C "space" D "Space and E with no empty cells between.

 

[Fluff]

Can you post some sample data & expected results.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[PuntingJawa]

Can you post some sample data & expected results.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

Sure thing! I am trying to filter where it looks like the below XL2BB.

Book2
	A	B	C	D	E	F	G	H	I
1	DATA					EXAMPLE
2	AREA	S/N	PN1	PN2		AREA 1	AREA 2	AREA 3	AREA 4
3	3	DMC233217	D7323-000166	SP455211				DMC233217 D7323-000166 SP455211	DMC233221 D7323-000166 SP455211
4	3	DMC233218	D7323-000166	SP455211				DMC233218 D7323-000166 SP455211	DMC233226 D7323-000166 SP455211
5	3	DMC233220	D7323-000166	SP455211				DMC233220 D7323-000166 SP455211
6	4	DMC233221	D7323-000166	SP455211
7	4	DMC233226	D7323-000166	SP455211
Sheet1

 

[Fluff]

Thanks for that.
How about

Fluff.xlsm
	A	B	C	D	E	F	G	H	I
1	DATA					EXAMPLE
2	AREA	S/N	PN1	PN2		AREA 1	AREA 2	AREA 3	AREA 4
3	3	DMC233217	D7323-000166	SP455211				DMC233217 D7323-000166 SP455211	DMC233221 D7323-000166 SP455211
4	3	DMC233218	D7323-000166	SP455211				DMC233218 D7323-000166 SP455211	DMC233226 D7323-000166 SP455211
5	3	DMC233220	D7323-000166	SP455211				DMC233220 D7323-000166 SP455211
6	4	DMC233221	D7323-000166	SP455211
7	4	DMC233226	D7323-000166	SP455211
8
Sheet5

Cell Formulas
Range	Formula
F3:I5	F3	=DROP(REDUCE("",SEQUENCE(4),LAMBDA(x,y,IFNA(HSTACK(x,BYROW(FILTER(B3:D100,A3:A100=y,""),LAMBDA(br,TEXTJOIN(" ",,br)))),""))),,1)
Dynamic array formulas.

 

[PuntingJawa]

Thanks for that.
How about

Fluff.xlsm
	A	B	C	D	E	F	G	H	I
1	DATA					EXAMPLE
2	AREA	S/N	PN1	PN2		AREA 1	AREA 2	AREA 3	AREA 4
3	3	DMC233217	D7323-000166	SP455211				DMC233217 D7323-000166 SP455211	DMC233221 D7323-000166 SP455211
4	3	DMC233218	D7323-000166	SP455211				DMC233218 D7323-000166 SP455211	DMC233226 D7323-000166 SP455211
5	3	DMC233220	D7323-000166	SP455211				DMC233220 D7323-000166 SP455211
6	4	DMC233221	D7323-000166	SP455211
7	4	DMC233226	D7323-000166	SP455211
8
Sheet5

Cell Formulas
Range	Formula
F3:I5	F3	=DROP(REDUCE("",SEQUENCE(4),LAMBDA(x,y,IFNA(HSTACK(x,BYROW(FILTER(B3:D100,A3:A100=y,""),LAMBDA(br,TEXTJOIN(" ",,br)))),""))),,1)
Dynamic array formulas.

Thank you very much as always. If I need more columns I just switch the sequence number to a higher or lower number. This is exactly what I was looking for <3

 

[Fluff]

You're welcome & thanks for the feedback.