Lukket

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.

Færdigheder: Excel, Dataindførsel, Databehandling, Excel Macros, Excel VBA

Om klienten:
( 5 bedømmelser ) RICHARDSON, Australia

Projekt ID: #34296224

42 freelancere byder i gennemsnit $29 timen for dette job

(536 bedømmelser)
8.4
(435 bedømmelser)
8.2
(692 bedømmelser)
8.4
(552 bedømmelser)
8.0
(202 bedømmelser)
6.9
(394 bedømmelser)
6.8
(140 bedømmelser)
6.8
(95 bedømmelser)
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 Flere

$20 AUD på 1 dag
(258 bedømmelser)
6.6
nimiwebjuggler

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

$19 AUD på 1 dag
(107 bedømmelser)
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 Flere

$28 AUD på 1 dag
(185 bedømmelser)
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 dage
(107 bedømmelser)
6.1
(111 bedømmelser)
5.7
(149 bedømmelser)
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 Flere

$60 AUD på 1 dag
(32 bedømmelser)
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 på 1 dag
(35 bedømmelser)
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 dage
(28 bedømmelser)
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 på 1 dag
(13 bedømmelser)
4.2
(12 bedømmelser)
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 Flere

$20 AUD på 1 dag
(15 bedømmelser)
3.9