Forum Discussion
move data
It's difficult to envisage what you are trying to achieve without a visual representation.
Are you able to share sample data to facilitate an easier solution?
Cheers
I will post an example shortly after I disguise the data. Thank for the suggestion
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.
