Closed

Inserting variable number of copies of columns based on field data

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.

Skills: Excel, Data Entry, Data Processing, Excel Macros, Excel VBA

About the Client:
( 5 reviews ) RICHARDSON, Australia

Project ID: #34296224

42 freelancers are bidding on average $29 for this job

(536 Reviews)
8.4
(435 Reviews)
8.2
(692 Reviews)
8.4
(552 Reviews)
8.0
(202 Reviews)
6.9
(394 Reviews)
6.8
(140 Reviews)
6.8
(95 Reviews)
6.8
ibrahimstk

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 More

$20 AUD in 1 day
(258 Reviews)
6.6
nimiwebjuggler

Hi, I have great data entry skills. I will provide you best and accurate service with complete satisfaction.

$19 AUD in 1 day
(107 Reviews)
6.0
PERPETUAL0

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 More

$28 AUD in 1 day
(185 Reviews)
6.0
Rajni0802

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
(107 Reviews)
6.1
(111 Reviews)
5.7
(149 Reviews)
5.5
raoarslan56

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 More

$60 AUD in 1 day
(32 Reviews)
5.3
Barroga17

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
(35 Reviews)
4.9
Mhossain007

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
(28 Reviews)
4.7
rabbiawebjuggler

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
(13 Reviews)
4.2
(12 Reviews)
4.3
Maherun75

"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 More

$20 AUD in 1 day
(15 Reviews)
3.9