Combined data into 1 cell

Hello I have data in 2 cells and I want to combine it in another cell on a different tab.

However there would be multiples of this data repeated in the combined cell. Once new data is entered in the row below for the 2 cells i want the cell to display that.

Currently i have this

=IF(ISBLANK('Inspection Record'!$H3),'Inspection Record'!$H$2 & "," & " " & "DN" &" " &'Inspection Record'!F$2,'Inspection Record'!$H3 & "," & " " & "DN" &" " &'Inspection Record'!F3)

So if H3 is blank I want to display what is in H2 and F2 until data is put into H3 then i want to display that and so on. So if H4 is blank it will display H3 and F3.

Is this possible with a formula ?

Any help would be appreciated

Thank you

maybe it will be easier:

Formula:

Please Login or Register  to view this content.

next row after drag down

Formula:

Please Login or Register  to view this content.

Hello Thanks for your help, but it increments on the next line. I don't want it to increment until something is put into h3 then they should all increment.
Maybe this cannot be done as a formula. As i would have multiple h2 then when the next job is entered on h3 the formula should increment to show what is in the h3 and f3 cells and so on.

it's hard to say something without any excel example file (not a picture)
try to prepare and attach here realistic example with generic data (without references to another files which you can add later)

Hello Sandy666,

I have attached an example so the Systems serial No Reg is where I am combining the data from Batch and Delivery note.

So every time a new Delivery not is entered i want the cells to increment in the formula

thank you for your help

Hello Sandy,
h
I want to achieve the combining of the Delivery note and the Batch number on the Systems serial no Reg from the inspection record. As this would be the same for multiple lines in the systems serial no Reg until the user enters a new delivery note and batch number in the inspection record and then that data is combined until the next delivery note is entered.

I hope that makes sense and thank you for your help

Regards,

Thank you I shall give it a try

You are welcome