Transfer data from Excel col. A to multiple columns in the same sh

[JackGombola]

A Excel 2003 spreadsheet has only one column of player data: column A. The
first three data items in column A are the same for every player: Name,
Address and Phone. Every player also has at least one comment but could have
any number of comments. Each player’s data is separated from the next by a
blank cell in column A. Sometimes, a player’s last comment is blank
resulting in two blank cells in column A before the data for the next player.

I need an Excel 2003 VBA macro to:
1. Copy just the player’s name, but not the Name: label, to column B as shown.
2. Copy just the address, but not the Address: label, to column C
3. Copy just the phone, but not the Phone: label, to D
4. Combine all of the player’s comments, but not the original Comment:
label, into one paragraph and paste into E2.
Repeat the above process, ignoring the blank row separating the players, for
all the player data in column A.
A B C D D
Name:John John Main St 555-1212 Plays 1st base.
Plays 2nd base. Plays 3rd base.
Address:Main St Jane Center St 555-1213 Catches well. Has
played center field.
Phone:555-1212
Commentlays 1st base
Plays 2nd base
Plays 3rd base

Name:Jane
Address:Center St
Phone:555-1213
Comment:Catches well
Has played center field