Column Data to row

[Jranchhod]

Hi All

I have a data set of names in column A and in Column B, C, D I have telephone numbers of the names.

How can get the telephone numbers all in Column B underneath each other next to the name eg.

From below
A B C D
Jetash, 011 25522 , 523656, 215136213

To Below

A B
Jetash 011 25522
Jetash 523656
Jetash 215136213

Thank you in advace

Jetash

 

[Useful]

Hello,

=INDEX($B$2:$B$10,SMALL(IF($A$2:$A$10=E2,ROW($B$2:$B$10)-ROW($B$2)+1),COLUMNS($A:A)))

E2 is the name in your case "Jetash" and donw to the list. You need to create unique list of names first and use them a criteria like this (E2).

This is an Array formula and enter this with Ctrl+Shift+Enter and drug it to right side for the D and E and etc columns