Thanks Shane. I'll try it and let you know how I make out.

Bob

"ShaneDevenshire" wrote:

Hi Bob,

you don't need a macro. In cell H1 (assume row 1 is the first row) enter the
formula =IF($C1="Per",B2,"").
Copy this formula to the right as far as necessary.
Highlight H1:M2 and use the fill handle to fill down as far as necessary.
Highlight all the formula cells, say H1:M1450 and choose Copy, then choose
Edit, Paste Special, Values.

--
Cheers,
Shane Devenshire
Microsoft Excel MVP

"Bob Hopson" wrote:

I would like a macro to do the following:
I have two rows to concatenate
The first row has columns A through G
The second row has columns B through G
I would like to append the second row to the end of the first row starting
in column H. If Col C ='PER' append second row starting in column H of first
row

The are 1450 records to do this for.

Thanks