I have a spreadsheet with about 1600 columns. These columns contain words. I need copies of the columns made based on the field data. e.g. If cell AT7 has two names in it (separated by " / ") and AT9 has three names in it (separated by " / "), I want that column copied and five copies of it inserted ((2 names * 3 names) - the 1 existing column). That's the main part of the task I want done.
However, if you can automate the next step, that will be highly desirable.
Now that those extra columns have been added in, I'd like each of those 6 columns to have different combination of the names appear.
e.g. Cell AT7 contains "æwwɑ / i:zlɑ" and cell AT9 contains "ærnθɑ / here / her", therefore I would like the following data outcomes in a lower row:
If that second step can be done, then also the same outcome for AT8 and AT10 cells for AT12:AY12.
Happy to clarify further or any any questions. Have attached the document to demonstrate. Note that columns E to AR are a "done by hand" manual processing of what was once Column E's data. So I'm only looking for it to be implemented from Column AS onwards.
Important: Please only bid the actual amount you're happy for me to pay you to do the job. If you bid a lower amount in your quote and later ask for a higher amount, we won't be the right fit for each other.
42 freelancere byder i gennemsnit $29 timen for dette job
Hello Client, I can manage this task of inserting variable number of copies of columns based on field data and as per the instructions provided in project
Hi I am an expert in Excel and VBA application. With my knowledge in excel, I can help you with this task fast and accurate. Contact me to discuss. Regards!
Hi, I am interested to work on this project. This would be great if you please consider my application. I will ensure on time delivery and 100% accuracy. Thanks, Moazzam
Hi I am expert in Data entry, Web search and also Alison certified in excel. I am ready to start now Quality is my top priority Ping me back for further discussion Thank you!