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 freelances font une offre moyenne de 29 $ pour ce travail
Hi David I am ready to start Data entry work to Inserting variable number of copies of columns based on field data as per details in your project and able to make it professional within a short time frame. I checked Plus
Hi, I have great data entry skills. I will provide you best and accurate service with complete satisfaction.
Hello Sir , Iam excel expert level with top rating done projects before I can done this within short time also i can provide previous samples for make you understanding better about me and my skills. When do you need Plus
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
Here sir I have read your job description very carefully,I am an excel VBA expert, I would like to built you VBA script to performall all three tasks mentioned in job description I can start immediately. I will take 14 Plus
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!
"Dear Client, I specialize in Word or Excel VBA / Macro solutions and Web Scraping/Data Mining for your Excel workbooks. I will perform any tasks in Excel to automate your business. VBA macros, custom forms, charts, ta Plus