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.
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?
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
19 фрилансеров(-а) в среднем готовы выполнить эту работу за $24
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
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.
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