copy data from one cell to another
 

ok I have the following spreadsheet setup:

Augusta Items(Section Header)
PW Pitching Wedge 12.00
SW Sand Wedge 13.00
PT Putter 14.00

Now I want the words "Augusta Items" to be added to each row in the last
column after the price.

Ok here is the kicker, I have several sections like did running down the
spreadsheet, and they all have different section header names. What formula
or macro that I need to use to copy the section header to each record below
them and when it comes to the next section header, it would copy that header
until it reaches the end of the spreadsheet. Please help