Text file lines to Excel Column

Hi,

I want to import a text file having rows/line to Column in my excel file.

Sample Text File:

Name of person
Date
Amount
City
State
Pin
Reference
Name of person
Date
Amount
City
State
Pin
Reference

I want to copy line 1 to Column A, Line 2 to Column B, Line 3 to Column C, Line 4 to Column D, Line 5 to Column E, Line 6 to Column F, Line 7 to Column G.

Result: [TABLE="border: 1, cellpadding: 1, width: 700"]

[tr]

[td]

Column A

[/td]

[td]

Column B

[/td]

[td]

Column C

[/td]

[td]

Column D

[/td]

[td]

Column E

[/td]

[td]

Column F

[/td]

[td]

Column G

[/td]

[/tr]

[tr]

[td]

Name of person

[/td]

[td]

Date

[/td]

[td]

Amount

[/td]

[td]

City

[/td]

[td]

State

[/td]

[td]

Pin

[/td]

[td]

Reference

[/td]

[/tr]

[tr]

[td]

Name of person

[/td]

[td]

Date

[/td]

[td]

Amount

[/td]

[td]

City

[/td]

[td]

State

[/td]

[td]

Pin

[/td]

[td]

Reference

[/td]

[/tr]

[/TABLE]

Thanks.