Hi I have a very confusing task i have a column with Employee IDs concatenated in one column in an excel sheet as shown below i want them to be separated and placed in multiple columns highlighted as Bold with one Employee ID in each column. Also i want a separate output which gives me Employee ID and count of each instance of that employee ID
Ok here is the revised version contains both your original and new request. I think it does what you have mentioned. I have revised the original version with Dawn's suggestion - splitting to rows is much elegant. Noticed duplicates in your data, row 7 and 11 - I guess you are aware of them.