Taking duplicates of Rows in excel based on First column

[SahadhKuruniyan]

Hi Team,

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

Team	Control	status
A,B	1	Good
C	2	Okay
A,B	3	Good
B	4	Good

I need to convert like below:

Team	Control	status
A	1	Good
B	1	Good
C	2	Okay
A	3	Good
B	3	Good
B	4	Good

[binu_acs]

@SahadhKuruniyan One way of doing this