move data

Question

Hi.&nbsp; Any help will be appreciated.&nbsp; I need to move data on multiple rows into one row to create a mail merge.&nbsp; Each customer has anywhere from 2 to 6 rows of data with 5 columns being the data I need.&nbsp; The rest is repeated identification data.&nbsp; I need to move the data from 5 of the cells in each row into the first row with that has customers id. So I need excel to identify if the next row is the same customer, move the data if true, then delete the row it moved the data from.&nbsp;I can move it with "if" and "offset", but I don't know how to make the formula move to the next row after its captured the 5 cells I need unless I manually change it which will take forever. For example, once a drag the formula 5 cells, I need the "if" command to change from comparing A2=A3 to A2=A4.&nbsp; &nbsp;I would also like to delete the row once the data has been moved which I don't know how to do unless I search for a VBA command.&nbsp;Not sure if I'm on the right track or if I am making it too complex.I am not great with pivot tables but could figure that out as long as it works with the mail merge.&nbsp; I have not worked with them very much and don't want to try it unless I am sure it would work.&nbsp;Thanks for any help.

wumolad · Answer

robscheerger&nbsp;&nbsp;It's difficult to envisage what you are trying to achieve without a visual representation.&nbsp;Are you able to share sample data to facilitate an easier solution?&nbsp;Cheers&nbsp;&nbsp;

robscheerger · Answer

&nbsp;I will post an example shortly after I disguise the data. Thank for the suggestion&nbsp;wumolad&nbsp;

wumolad · Answer

robscheerger&nbsp;&nbsp;ok

robscheerger · Answer

I need to send about 600 letters based on this data with about 5000 rows in total.&nbsp; Within the letter is a table for me to enter the service data and explain how its being provided in the pandemic.&nbsp; The database produced one row per service so most of the customer data is repeated as you see but I need to service data.&nbsp; 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,&nbsp; THanks for your help.wumolad&nbsp;

Forum Discussion

move data

4 Replies

Resources