suppose data is like this from A1 down to A9
now in sheet 1 in A1 type (or copy paste this formula)
copy A1 both down and to the right till you get 0
delete 0s. do you get what you want?
In sheet1 now you are having 3 sets of data. you can have as many sets as you like but in each set the first is name, second address and third phone no;.