Taking duplicates of Rows in excel based on First column

Question

Hi Team,

I am new to excel and I need to split rows based on Team column,

TeamControlstatusA,B1GoodC2OkayA,B3GoodB4Good

I need to convert like below:

TeamControlstatusA1GoodB1GoodC2OkayA3GoodB3GoodB4Good

binu_acs · Answer

@SahadhKuruniyan One way of doing this