Find Jobs
Hire Freelancers

Inserting variable number of copies of columns based on field data

$10-30 AUD

Completed
Posted almost 2 years ago

$10-30 AUD

Paid on delivery
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: AT11: æwwɑærnθɑ AU11: æwwɑhere AV11: æwwɑher AW11: i:zlɑærnθɑ AX11: i:zlɑhere AY11: i:zlɑher 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. Thank you.
Project ID: 34296224

About the project

42 proposals
Remote project
Active 2 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
$0 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
42 freelancers are bidding on average $29 AUD for this job
User Avatar
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 your details and understand your requirements. I am expert and professional worker in data entry. This is a straightforward work! I can promise you great work right now! Please send me a message You can check my profile here for details at https://www.freelancer.com.bd/u/ibrahimstk 940+++ project done perfectly. Looking forward to your reply Thanks Ibrahim
$20 AUD in 1 day
4.9 (263 reviews)
6.6
6.6
User Avatar
Hi, I have great data entry skills. I will provide you best and accurate service with complete satisfaction.
$19 AUD in 1 day
4.9 (108 reviews)
6.1
6.1
User Avatar
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 this finished? I understand how annoying it is and can get this fixed for you quickly! Please see the sample I fixed. I look forward to working on this project with you. Regards ILYAS
$28 AUD in 1 day
4.9 (192 reviews)
6.0
6.0
User Avatar
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
$30 AUD in 3 days
4.8 (107 reviews)
6.1
6.1
User Avatar
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-15 hrs to create this code to you. Text me to discuss more please.
$60 AUD in 1 day
5.0 (35 reviews)
5.4
5.4
User Avatar
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!
$10 AUD in 1 day
5.0 (35 reviews)
4.9
4.9
User Avatar
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!
$10 AUD in 1 day
5.0 (21 reviews)
4.8
4.8
User Avatar
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
$10 AUD in 7 days
4.8 (28 reviews)
4.7
4.7
User Avatar
"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, tables, absolutely any request will be satisfied. If necessary, I will write accompanying documentation or video. Ready to solve a problem of any level of complexity. Services Offered: ✅Automating Tasks. ✅Data Validation. ✅Data Analysis. ✅Custom Formulas. ✅Creating User Forms. ✅Charts. ✅Pivot Tables. ✅Formatting, Fixing, Forms, Formulas, Functions. ✅VBA Macros Automation. ✅Web Scraping/Data Mining from any website and any amount of data. ✅Data collection, Images Downloadable / Images URL. At any time ready to provide support on emerging issues. I am happy to provide after-sales support, you can always count on me. ""✌️People like surprises and here I come into play, to present your ideas to the world in the best manner✌️"". Please don't waste your time looking around. Please feel free to contact me. I'm ready to start your project. Thanks in advance!"
$20 AUD in 1 day
4.8 (16 reviews)
4.0
4.0
User Avatar
Hi I've read the project description carefully. I'm an expert in Excel VBA. It would be a great pleasure for me to have the opportunity working with you. ✓ Looking forward to hearing more about your project via chat. plz check my profile in here: https://www.freelancer.com/u/anenkovakateryna. Best regards!
$100 AUD in 2 days
4.6 (5 reviews)
3.8
3.8
User Avatar
I can easily do this using python pandas or openpyxl. I have around 5 years of python experience. Let me know. I am really interested in this job. I am currently working as a Senior Data Engineer in an IT Company. I'm offering the best quality and highest performance at a price we are both comfortable with. I can complete your project on time and your will experience great satisfaction with me. I'm well versed in Python,Unix Scripting, Excel VBA etc . I have rich experience in Word, PDF, Data Processing, Data Entry, Web Scraping. For more information about me, please refer to my portfolios. I'm ready to discuss your project and start immediately. Looking forward to hearing you back and discussing all details Thank you! Ashish Dudeja
$20 AUD in 7 days
5.0 (2 reviews)
3.6
3.6
User Avatar
Hello, I like to work with you i am a expert in make Excel file. I read your concern and it is easy task for me if you can give me a chance i will do your work in your time with best quality work.
$10 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Computer science graduation complete Computer Course Name : Tally, PGDCA Complete Fast typing experience 3year
$20 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i am redi 2 din me ..
$20 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am interested to take ur project . If possible please send me . I will complete within given time period. Massage me ASAP.
$20 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello sir I have read your project description carefully and i am willing to work with you on this project pls discuss the other details over the chat... thanks
$10 AUD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi! Hope you're doing good .I am sure that I'll be the best fit for this task .I have good command over typing .my typing speed is too good please give me a chance to complete this task I try my best and I never disappointed you
$20 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi there... I am interested in your project. I am going to do it for absolutely free . I want to discuss further details about this project. Thanks you Karan kumar
$10 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I Am Very Hardworker And Honest I Never Leave My Work Unfinished So I Sure That You Will Give Me Work And I Will Do This Work With You Honestly. Thank you......
$10 AUD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello! I would be glad to help you. It almost a not difficult task that can be done with less lines of code (none error or response management, except finish responce). I'm new here and need some references, so would do it for minimum money in less then 2 days (evenings).
$10 AUD in 2 days
0.0 (1 review)
0.0
0.0

About the client

Flag of AUSTRALIA
RICHARDSON, Australia
5.0
5
Payment method verified
Member since Jan 13, 2022

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.