Excel 2007 : import text data into specific format using VBA / macro ?

PLEASE IGNORE (OR DELETE) THIS THREAD. I WILL REWORD MY QUESTION IN A SIMPLER MANNER.

Hi folks. Retarded question here.

1] I have a text file that contains a filtered list of 10,000 people who are likely to take part in a product review focus group session throughout the year.

2] I need to import this text file data into Excel 2007 in a specific order/format (which is different from the order of the data in the text file).

3] Can a VBA script be written for Excel 2007 that allows it to grab/re-arrange the text data into specific cells?

4] Finally, I need to auto-fill/replicate this process inside Excel for every one of the 10,000 respondents in the text file.

I have attached a link to a screen cap which displays the first two samples of the text file attempting to show what I mean by all this.

Any help is appreciated. Thanks!

http://oi56.tinypic.com/2m5huee.jpg