On Mar 20, 3:25*pm, Pete_UK wrote:
Put this in N3:

=IF(ROW(A1)COUNTA(A:A),INDEX(H:H,ROW(A3)-COUNTA(A:A)),A3)

and copy it down as far as you need. It assumes contiguous data in
column A, i.e. no blank cells until the end of the data.

Hope this helps.

Pete

On Mar 20, 6:41*pm, clk wrote:



Yes it seems like it would be a simple process but there are many
people using this spreadsheet and for some reason it doesn't seem so
easy for some. *I have code working that will combine the data. *I was
hoping for a formula so they didn't have to run a macro but the code
may be the only way to go- Hide quoted text -

- Show quoted text -

Hi. Thank you for your response. This almost works. :.) I
appreciate the help. It will work on the data in column A but leaves
two blank cells then copies down column H data. I am not sure why I
am getting two "zero" entries between column A data and column H data.

I have a heading in A1 and a subheading in A2. Data starts in A3.

Any help would be appreciated.

~ Carrie