Need a help.

[Maddy]

Hi Team, I need a help in attached sheet. Can somebody please help me to segregate all data.

Actually numbers are mentioned twice in row . I want to know how can I separate Name, Contact number and count separately as count has been duplicated her. Please suggest.
Madhoor

 

[Hareesh_KLD]

Hi

Check the attached sheet

 

[bosco_yip]

Or..........

In C1, copied across to F1, and all copied down until blank

=OFFSET($A$1,(ROWS($1:1)-1)*4+COLUMNS($A:A)-1,)

Regards
Bosco

 

[Maddy]

thanks Bosco.. it would be my pleasure if you brief me the login how was it done.
thanks