Import Excel 2003 file to Access

[cohrsman]

Have a excel file that I eventually will import to access. The excel file has info about people that I want to put into an access database to make it easier to generate my own reports. The problem I have is...since access associates each row as an individual record. I need a macro to take data from multiple rows and moves it all into one row (end result will be..access will see 1 record with all info). I highlighted one person's info on attached file as example of everything that should be on one row. Additionally, there are some cells that will be blank because they have no data. I attached a file and changed personnel info, but the format is the same. Can anyone help?

[cohrsman]

bump..made some changes to clarify