HELP with merging cells

Copper Contributor

I have the following format from an A2i report, the data is duplicating info because the description line in column I is on separate lines in our operating system.  I know how to merge all the description info to one line using concat function, but i need ALL the data to be on one line. 

So it should show the all columns on 1 line.  As you can see, the column D and column F is on the line above and then all the description lines are on multiple. 

 

I need this to be done via a mass maintenance way if possible because there is over 400 accounts like this.

2 Replies
Can you provide a simple (made-up) example (in Excel, not Word!) with just a couple of lines of data along with the expected outcome please?

@StephanieLewis

 

Yes, you need to provide the sample data and we will try to provide the solution.  Please don't expect the people to re-create your problem so they can help you come up with a solution.  Thank you.