Forum Discussion

robscheerger's avatar
robscheerger
Copper Contributor
Aug 27, 2020

Move Data into one cell with identifier

Hi.  Thanks for any help.  I need to send about 600 letters based on this data with about 5000 rows in total.  Within the letter is a table for me to enter the service data and explain how its being provided in the pandemic.  The database produced one row per service so most of the customer data is repeated.    For me to do the mail merge for each individual I want to take the service data (service,frequency, duration, explanation of services) put it in one row per individual so I can do the mail merger in word,  

I have tried to use if and offset, but I am having trouble make it go to the next row after the data has been moved.  

It would be great if I could delete the row after the data is moved.

excel
Formulas and Functions
Macros and VBA

1 Reply

  • ExcelExciting's avatar
    ExcelExciting
    MVP
    Aug 27, 2020

    Hi robscheerger

     

    Please correct me if I'm wrong, you are trying to combine rows of unique customer into one row.

     

    If you have office365 you can use the new filter function to do that and join the text using textjoin. if you wish to make it unique then use unique function.. sample file attached > check working sheet2

     

     

    Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

    If you find the above solution resolved your query don't forget mark as Official/Best Answer to help the other members find it more