CHANGING FORMAT OF EXCEL DATA VIA VB

[fsweb2002]

Hi
I have an EXCEL file with the following format:

shipping lines
Ports APL COSCO K-LINE ETC
hong kong 20 100 200 200
40 200 300 300
40HC 300 400 400
shanghai 20 400 500 550
40 800 1000 1200
40HC 900 1100 1300
etc

There are over 20 shipping lines (columns) and over 100 ports (rows)

I need to convert it to Access as follows:
20 40 40HC
hong kong APL 100 200 300
hong kong COSCO 200 300 300
hong kong K-LINE 200 300 400
shanghai APL 400 800 900
shanghai COSCO 500 1000 1100
shanghai K-LINE 550 1200 1300

Anyone has any VB code (or some other idea) on how to do this??

Your help is always appreciated