Problem in Concatenate

[bizlife]

I have an excel file where in column A I have few asset IDs, against each asset ID there are multiple Descriptions. I want all the descriptions to be in single cell with a line break in between each value. I used the concatenate function but that takes a lot of time, moreover I have to do a lot of manual stuff to apply the concatenate formula. Since the file is very large I have attached a sample of the data.

Thanks in advance.

 

[NARAYANK991]

Hi ,

I am not able to understand your statement :

I have to do a lot of manual stuff to apply the concatenate formula.

See if this is an improvement.

If you have Excel 2016 , you can use the TEXTJOIN function which may make it simpler.

Narayan

 

[bizlife]

I am using excel 2013. I created an addin for textjoin and that worked. Thank you.