Concatenate multiple rows

[pjandshelly]

I have sentences on adjacent rows. I am wanting to concatenate those into one row. What would the formula be to create that? Thank you for any assistance.

 

[Joe4]

If you have sentences in A1, A2, and A3 that you want in a single cell, you can use:

=CONCATENATE(A1,A2,A3)

 

[pjandshelly]

If you have sentences in A1, A2, and A3 that you want in a single cell, you can use:

=CONCATENATE(A1,A2,A3)

Sorry, I didn't add the kicker and not sure if this is possible.

I have a list of items in column d, in column e, the description of those items are there. In column e, the description is put in a few different rows. So how would I concatenate if in cell d is blank, concatenate column e that is next to column d with information and also the line below it if column d is blank. I hope this all makes sense.

column d column e

xyz This is a
test

Final product:
column d column e

xyz This is a test

 

[Joe4]

Yes, you want to be sure to post complete, detailed questions.
Otherwise, oversimplified questions probably lead to oversimplified answers that won't work for you, since we didn't have the pertinent details.

Your request sounds a lot like one I helped out on earlier today.
See if this helps: https://www.mrexcel.com/forum/excel-questions/1042362-conditional-append-data.html

 

[pjandshelly]

Thanks, this is great. Is there a formula that would be able to do the same thing? or does it have to be through a macro?

 

[Joe4]

Is there a formula that would be able to do the same thing?

Not easily. It would probably have to be some sort of array formula that is beyond my knowledge. It would have to be done in a separate range though. Formulas cannot delete rows on a sheet.