I am trying to manipulate some address data so that it can efficiently be printed onto labels. I copy and paste it from the source into my excel file. The problem is that the addresses are either 5 or 6 rows each and there is then 9 blank rows between each address. Currently I manually go through the data and delete one of the blank rows below any 6 row addresses. This results in the start of each address being 15 rows apart, and from there I have no issues in getting them printed onto labels nicely.
Therefore my query being, is there a way to get excel to manipulate the data so that I can avoid having to carry out the manual task of deleting rows as this is quite time consuming?
14 freelancers are bidding on average £18 for this job
Hello, I’m an Excel expert and I would like to help you automate this process. Please check my profile and contact me to discuss further details. Regards. Stay tuned, I'm still working on this proposal.
its my pleasure to do that Relevant Skills and Experience i have done some skill course on the same Proposed Milestones £18 GBP - its my first timme