Fermé

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.

Compétences : Excel, Saisie de Données, Traitement de Données, Excel Macros, Excel VBA

Concernant le client :
( 5 commentaires ) RICHARDSON, Australia

Nº du projet : #34296224

42 freelances font une offre moyenne de 29 $ pour ce travail

(536 Commentaires)
8.4
(435 Commentaires)
8.2
(692 Commentaires)
8.4
(552 Commentaires)
8.0
(202 Commentaires)
6.9
(394 Commentaires)
6.8
(140 Commentaires)
6.8
(95 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(258 Commentaires)
6.6
nimiwebjuggler

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(107 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(185 Commentaires)
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(107 Commentaires)
6.1
(111 Commentaires)
5.7
(149 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(32 Commentaires)
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!

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(35 Commentaires)
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(28 Commentaires)
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!

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(13 Commentaires)
4.2
(12 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(15 Commentaires)
3.9