Flat File To DB Upload Approach Question

Hi guys,

Suppose I have a flat file that had columns that went like this:

rackId, cdname1, artist1, year1, cdname2, artist2, year2, cdname3, year3, artist3,...cdnameN, yearN, artistN

And I want to map it to a table that has the ff columns:

rack_id | CDName | Year | Artist

Assuming that N is constant and all rows of the flat file will have N or less values filled up per rack, how do I map the fields from the flat file such that cdname1, cdname2 and cdname3 all fall under the CDName column, year1 and so on will fall under the Year column, and artist1 and so on will fall under the Artist column?