Need Help in loading differnt line data in Teradata table

General

Need Help in loading differnt line data in Teradata table

Could you please help me with function/ query to load teradata table from flat file which contains records in different lines.

Sample file

Name ABC

Place Mumbai

Country India

Name DEF

Place New Jersey

Country USA

Name GHI

Place Pune

Country India

Excepted Result






Name City Country
ABC Mumbai India
DEF New Jersey USA
GHI Pune Inda