I have data in which column 'C' have cells which contain multiple values separated by (,).Now I want to get atomic values in all cells of column 'C'. i.e. that for a cell when there is more than one value; separated by (,) it should be copied in the next row with all the other columns of that row copied with the value we want to separate, in the next row...
In simple I want my data to be in 1NF.
fashxfreak
3
Newbie Poster
Recommended Answers
Jump to PostI have data in which column 'C' have cells which contain multiple values separated by (,).Now I want to get atomic values in all cells of column 'C'. i.e. that for a cell when there is more than one value; separated by (,) it should be copied in the …
Jump to PostI'm not saying this because I want to push people away from this site but this can more than likely be solved at an Excel site. You'll be able to post a workbook where people can work with what you have. Am I able to provide a link to a …
All 8 Replies
LastMitch
Stuugie
50
Marketing Strategist
fashxfreak
3
Newbie Poster
Stuugie
50
Marketing Strategist
Stuugie
50
Marketing Strategist
fashxfreak
3
Newbie Poster
Stuugie
50
Marketing Strategist
fashxfreak
3
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.