Forum Discussion
move data
Hi. Any help will be appreciated. I need to move data on multiple rows into one row to create a mail merge. Each customer has anywhere from 2 to 6 rows of data with 5 columns being the data I need...
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 as you see but I need to service data. 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, THanks for your help.