Copy heading to rows below

Hi could anyone help with the enclosed file.

I have an export of data as shown in the first tab called 'Raw data' which shows 3 machines with audit details, however to allow me to filter and sort I would like the machine name in C1, C19 & C31 to show in row A against each of the total rows (See 'Result Required' tab)

I would like the same to happen to the machine ID in F1, F19 & F31 to show in column B again against each total row.

I presume an 'IF' type formula may help but as each machine has different numbers of rows as shown, I have struggled to find an answer.

This is just a sample but the real file could have 200 plus machines ranging from 2 to 20 plus total rows per machine.

Any help much appreciated.

G

Insert a blank row at the top of your data, then you can use this formula in A2:

=IF(ISNUMBER(F2),C2,A1)

and this one in B2:

=IF(ISNUMBER(F2),F2,B1)

Then copy both formulae down as far as you need to.

Hope this helps.

Pete

Hi All,

Many thanks for all your speedy responses and all of the options will work perfectly for what I want.

Thanks Again.

Garry