Excel - insert data to many lines based on a set of ID numbers

Does anyone know what type of macro could help with my problem.

I have a spreadsheet. Column A has an ID (example Test and Apple). Each ID has a set of data in the different rows. See example below:

Date State

Test 4/1/14 TX
Apple 5/1/14 NY



The problem is every data line has information that needs to be added to not only the ID but now a subset (can be more than one number) in addition to the ID. For example, my first ID is Test. Now the subset ID number of 1, 2 and 3
So now the data needs to go into excel as this:


Date State
Test.1 4/1/14 TX
Test.2 4/1/14 TX
Test.3 4/1/14 TX

But Apple only has two subset IDs:

Date State

Apple.1 5/1/14 NY
Apple.2 5/1/14 NY


Every ID varies in the amount of subset IDs but all the information on the ID line has to hit the subset ID.

Please help! Thanks!

BTW - date and state should be on pushed out further in different columns, this site formats back to the first space