Macro: Combining a list of notes into one cell

[glide2131]

Hello,

I have a long list of records and each record has a list of notes. Some have one note and others have many lines of notes. What I need to do is combine all the notes for each record into one cell. I know how to do this manually using TextJOIN but I have thousands of records and going through each manually would take forever. I am looking for a macro that can combine all of the notes into one cell by record. Or in other words, there should be one cell with all the combined notes per record (ID in my example)I have attached a spreadsheet as an example of what I need.

Please help.

Thanks!

[AliGW]

Administrative Note:

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

[Marc L]

Hi,

I pretty sure it's yet solved on another forum …

[glide2131]

Got it. sorry about that. Thanks