How to add if input is empty jump it

[frne]

Hello,



I have this formula:
$B$1&":"&B2 &" "& $C$1&":"&C2 &" "& $D$1&":"&D2 &" "& $E$1&":"&E2 &" "& $F$1&":"&F2 &" "& $G$1&":"&G2 &" "& $H$1&":"&H2 &" "& $I$1&":"&I2 &" "& $L$1&":"&L2 &" "& $M$1&":"&M2 &" "& $N$1&":"&N2 &" "& $O$1&":"&O2 &" "& $P$1&":"&P2 &" "& $Q$1&":"&Q2 &" "& $R$1&":"&R2 &" "& $S$1&":"&S2

I have a matrix based on different coloumns for each value for every row.

I would add to the formula "if value on the coloumn is empty, jump it". Otherwise I would have like "Coloumn1: " withouht nothing, because there isn't matching value

 

[Fluff]

Hi & welcome to MrExcel.

Can you post some sample data, along with expected result.
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.

 

[frne]

Model

Article

Vendor

Season

Category

Gender

Name Model

colour

Size & fit

1010

10

UP1

Winter

Sneakers

Donna

handball

black

Regular fit

Here an example of matrix

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1		Model	Article	Vendor	Season	Category	Gender	Name Model	colour	Size & fit
2		1010	10	UP1	Winter	Sneakers	Donna	handball	black	Regular fit										Model:1010 Article:10 Vendor:UP1 Season:Winter Category:Sneakers Gender:Donna Name Model:handball colour:black Size & fit:Regular fit
Data

Cell Formulas
Range	Formula
T2	T2	=TEXTJOIN({":"," "},,TOCOL(B1:S2,,1))

 

[frne]

Result Desired as bullet point list
Mode:1010
Article:10
Vendor:UP1

 

[Fluff]

In that case try

=SUBSTITUTE(TEXTJOIN({":","|"},,TOCOL(B1:S2,,1)),"|",CHAR(10))

 

[frne]

Can you have a look at this and correct it?

=LET(a;HSTACK(B2:I2;J2:S2);TEXTJOIN(CODICE.CARATT(10);;IF(a="";"";HSTACK($B$1:$I$1;$J$1:$S$1)&":"&a)))

 

[Fluff]

What's wrong with the formula I suggested?

 

[frne]

I need bullet point list, like this and if the matching value in the row is empty, don't show the column name

Codice Articolo:2762
Brand:AMA BRAND
Stagione:Primavera / Estate 2024
Categoria:Sneakers
Genere:Donna
Colore:Bianco
Size & fit:Regular fit
Fantasia:Tinta unita
Forma punta:Tonda
Interno:Tessuto
Tomaia:Pelle
Suola:Gomma
Altezza suola:1 cm
Dettagli:Un modello in pelle caratterizzato da linee sinuose. Dettaglio glitter. Etichetta logo talloncino. Colore bianco/oro/stampa"

 

[Fluff]

That does not answer my question.
Please post some data that shows any problems you are having & use the XL2BB add-in, so that I can see which columns are which & what the formula is.