Jul 21 2021 08:42 AM
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.
Jul 22 2021 07:19 AM
Jul 22 2021 08:35 PM
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.