Inserting variable number of copies of columns based on field data
Budget: $10 – $30 AUD
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.
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.