How would I import a text file with the following format:

FROM:

Application Name - AppNameA
<tab>Groups
<tab><tab>GroupA
<tab><tab>GroupB
<tab><tab>GroupC
<tab>Users
<tab><tab>User1
<tab><tab>User2

-------------------------------

TO:

ColumnA ColumnB ColumnC
AppName Group User

Thanks!