• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Split cell based on criteria

C

coolkiran

Member
Hi

Unfortunately I have few rows with three columns like below :

Column A Column B Column C
A, B, C True False
D, A, B False True
... etc

From Column A i want to split based on delimiter ","
Final Output like to be as follow :

Column A Column B Column C
A True False
B True False
C True False
D False True
A False True
B False True

Is this possible. Example file attached.
 

Attachments

Hi coolkiran,

Well see the attached file. Not a direct solution, but in 2 steps.
1. First deliminate Column A data through Text-to-Column in some column. Than copy Column B & C next to them.
2. Than use formula to bring in required format.

See the file.

Regards,
 

Attachments

Thanks Somendra for your reply, Only thing is Column A will not be standard, it will be either A some time it will be A,B or A, B, C, D so is that formula will works for if its A or A, B and A, B, C. If i have more entries then how to proceed? I will have maximum 70 entries seperated by ","
 
You must log in or register to reply here.
Back
Top