So, we have a spreadsheet that is generated by an external database with no options for modification of the way the spreadsheet is generated. The spreadsheet has 2 columns, one ID number and a description that goes with each ID. My problem is that the description field is broken into multiple cells for each paragraph of each record's description. When we unmerge the cells, there are then several blank rows under the ID column, which we have written a formula to fill blak ID's with the corresponding number (so the paragraphs are synch'd).
What I need to do is concatenate each description into a single cell, for import into a document, another spreadsheet or database (broken up descriptions need to become whole). The following is a simplistic example (words in each cell, instead of paragraphs):
ID | Description
---------------
11 | This
11 | is
11 | my
11 | data.
55 | This
55 | is
55 | my
55 | other
55 | data.
What I would like to see, without having to take the time to write a functional VBA-based solution (we have the code for it, but it will take too long in our CM-controlled environment to meet our deadline), is the following result for each ID record:
ID | Description
---------------
11 | This is my data.
55 | This is my other data.
Assistance would be greatly appreciated. Thanks.
What I need to do is concatenate each description into a single cell, for import into a document, another spreadsheet or database (broken up descriptions need to become whole). The following is a simplistic example (words in each cell, instead of paragraphs):
ID | Description
---------------
11 | This
11 | is
11 | my
11 | data.
55 | This
55 | is
55 | my
55 | other
55 | data.
What I would like to see, without having to take the time to write a functional VBA-based solution (we have the code for it, but it will take too long in our CM-controlled environment to meet our deadline), is the following result for each ID record:
ID | Description
---------------
11 | This is my data.
55 | This is my other data.
Assistance would be greatly appreciated. Thanks.