nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

389866_en-US

liliconcom

Concatenate columns with empty cells

Hi all,

I have a dataset with different columns that have some empty random cells (like the example in the table below). I would like to concatenate the values of the different columns and use the "_" to separate the content of the cells only if the content of the cells is different from empty value (as in column "concat" below). Does anyone have a suggestion on a how to to this operation in a smart way?

Thanks for your help!

Name	Age	Sex	Concat
Mads	31		Mads_31
		M	M
John	25		John_25
Julia	19	F	Julia_19_F

Advanced Statistical Modeling

Consumer and Market Research

Content Organization

Data Blending and Cleanup

Design of Experiments

Mass Customization

Quality and Process Engineering

Re: Concatenate columns with empty cells

Hi, here is yet another formula.

</CODE> <PRE><CODE class=" language-jsl">Concat Items( Words( :Name || "," || :Age || "," || :Sex, "," ), "_" )

</CODE> Cheers, Brady</LINGO-BODY><LINGO-SUB id="lingo-sub-389902" slang="en-US" mode="NONE">Re: Concatenate columns with empty cells</LINGO-SUB><LINGO-BODY id="lingo-body-389902" slang="en-US" mode="NONE">Here is one way of writing the formula <PRE><CODE class=" language-jsl">colList = {"Column 1", "Column 2", "Column 3"}; x = ""; For( i = 1, i <= N Items( colList ), i++, If( As Column( colList[i] ) != "", If( x != "", x = x || "_" ); x = x || Char( As Column( colList[i] ) ); ) ); Trim( x );