Concatenate Multiple row data in one cell

[Areif]

Hi Expert

I am working on a customer database but stuck on addressed Column need help

Sheet is attached with self explanatory explanation of expected result

 

[xlstime]

this is very normal requirement and we discussed this many times on this group.

Please see below url, also on top right side search functionality is available to search anything

http://chandoo.org/forum/threads/concatenate-multiple-cells-into-one-cell.30698/#post-182970

Hi Expert

I am working on a customer database but stuck on addressed Column need help

Sheet is attached with self explanatory explanation of expected result

 

[Areif]

Thanks for Reply , but my requirement is different and need to concatenate the addressed with Customer Name
Waiting for solution

 

[bobhc]

@xlstime has show you the way to get your answer but you do not seem to be prepared to do anything yourself.
Your answer is in a concatenation.

.

 

[ANKUSHRS1]

try this
do one thing don't keep blank cell in customer name...copy above cell data by using autofilter option ..

 

[deciog]

Areif

Another format in Excel 2016

Decio

 

[bobhc]

@ANKUSHRS1 and @deciog from the OP's post

need to concatenate the addressed with Customer Name

Why concat with all the " " , spaces are the in the cell just need a " " between Customers name and the concatenated address cells.

 

[bosco_yip]

Conditional concatenate……….

TEXTJOIN is a Excel 2016 new function.

Try this if you do not have this new function.

In E6, formula

=C6&IFERROR(INDEX(E7:E$25,INDEX(MATCH(TRUE,B7:INDEX(B7:B$25,IFERROR(INDEX(MATCH(TRUE,B7:B$25<>"",),),4))="",),)),)

and >> E6 >> Conditional Formatting >> choose Formula : =$B6="" >> format : select yellow color in Front and Fill >> OK

All Copy down

Regards
Bosco