Завершено

Excel Expert

I have a contact spreadsheet with several columns and 6,000+ rows. One column has a list of tags that each contact is labeled with and each tag in the cell is separated by a comma. I could easily split these by the comma but I need a separate column for each tag.

Example:

Contact A has tags red, blue, green

Contact B has tags red, blue, purple, green

When I split the tags by comma, I get 4 new columns but I need all red in the first column, all blue in the second column, all purple in the third, and all green in the fourth.

Contact A will put green in the third new column because there are only 3 tags.

How do I get each tag listed in their own column?

Квалификация: Excel, Ввод данных, Обработка данных, Visual Basic

Показать больше toronto excel expert job, excel expert financial models, money excel expert, need excel expert, excel expert independent contractor bid, excel expert finance job, excel expert service, freelance statistician excel expert, buy excel expert, excel expert freelance contract jobs, sound excel expert, excel expert contract, company needs excel expert, become excel expert, excel expert formulas

О работодателе:
( 0 отзыв(-а, -ов) ) houston, United States

ID проекта: #21853267

Поручен:

cgullapalli

HI, I am good at Excel, I see the requirement. It can be addressed with if condition and find the formula. Looking forward to work on the project. -Chandra

$30 USD за 1 день
(890 отзывов(-а))
8.0

19 фрилансеров(-а) в среднем готовы выполнить эту работу за $24

asifdwan

"Hi there! I'll finish this ASAP. Please award me the job and send me the file. I've read the project description and ready to start it right away. I'm an expert in Excel jobs. Please open the chat so that we can move Больше

$30 USD за 1 день
(250 отзывов(-а))
7.2
ksriniravi

Greetings! I can set up formulas such that each color appears in its own column (even if the number of tags varies across contacts). Please share the files. Being a full time freelancer working exclusively on Excel b Больше

$10 USD за 1 день
(191 отзывов(-а))
6.9
asadkhan3533

Please review my profile as i have relevant skills and experience required for this project. Kindly send me a message to discuss further. Thank you, Asad Khan

$18 USD за 1 день
(162 отзывов(-а))
6.6
Exactwork1

Sir, I Also have Great Experience in Manual Typing, Word, Excel, PDF, Data Entry, Web Search, Technical Entry, Typing, Data Processing and all type of Office Work. I am very professional in this job. I ensure you i wil Больше

$30 USD за 1 день
(136 отзывов(-а))
6.6
nwss1986

Hi, This can be done with built in functions of Excel. I can do it in an hour and can start right now. Please contact me, if interested. Thanks!

$20 USD за 1 день
(91 отзывов(-а))
5.6
$25 USD за 1 день
(52 отзывов(-а))
5.5
rashedkhanrubel

Hi, I have understand the project requirement & interested to interested to separate text in excel for this project. I will start right now. Please send a message so we can discuss more & start the project. Thanks.

$15 USD за 1 день
(35 отзывов(-а))
4.5
maurineted5

I can help in this [login to view URL]

$45 USD за 1 день
(0 отзывов(-а))
0.0
haroldyesid

Analista de datos a través de excel, poder bi y bases se datos Relevant Skills and Experience Power query, Excel

$25 USD за 1 день
(0 отзывов(-а))
0.0
Vigneshtamilvv

Hello sir, I read your job description and l am interested to perform on this project. Please message me for more details about this project. I am waiting for your kind response. Thanks Vignesh. G

$15 USD за 5 дней(-я)
(0 отзывов(-а))
0.0
$20 USD за 3 дней(-я)
(0 отзывов(-а))
0.0
Sharma16618

Hello There Greetings!! Hope you are having a great day. I have gone through your requirements and I am confident to get this writing job done for you. I acquire great knowledge of technical/nontechnical writing. I h Больше

$10 USD за 3 дней(-я)
(0 отзывов(-а))
0.0
niveshkumarjohn

Hi, I read your project details and want to work for you. I can easily do your job. We need some money for our personal work. I will give you all data less then 1 day for give me my best. If you want to hire me the Больше

$15 USD за 1 день
(0 отзывов(-а))
0.0
nasirgsm

I can create a script for you which can done work within seconds, contact me at telegram for further discussion @NasirGSM

$55 USD за 1 день
(0 отзывов(-а))
0.0
vijaypsrm

We will complete your project in a day. I have done similar projects and it will be deliver on time.

$25 USD за 1 день
(0 отзывов(-а))
0.0
sivasai2006

I need pictorial representation and need to discuss with you to get more detail, so that I can deliver the code for your requirement.

$10 USD за 1 день
(0 отзывов(-а))
0.0
umairwaqas321

You will feel good by working with me

$35 USD за 1 день
(0 отзывов(-а))
0.0
aimansamha

Dear Director of Human Resources, The attached resume details my extensive experience and training. If you choose to interview and hire me, you will not be disappointed. I'd be happy to provide greater detail about my Больше

$20 USD за 7 дней(-я)
(0 отзывов(-а))
0.0