How to customize data took from web into excel : How to customize data taken from web into excel

Example Data taken from Web getting displayed as below when paste into excel/word:


    1
    John
    Florida
    2
    Harish
    Los Angeles
    3
    Kiran
    Newyork
    4
    Gautam
    Washington

The expected tabular format as:

    Sl.No     Name     City
    1         John     Florida
    2         Harish   Los Angeles
    3         Kiran    NewYork
    4         Gautam   Washington


I tried with Text to columns or delimited etc  but not getting as expected output.