How to repeat Field Headings

[msg500]

Example

cars
cars escort 50
cars focus 20



bikes
bikes triumph 10
bikes ducatti 5




Hi,
Is there a formula to repeat the field headings cars and bikes on the left hand side. I have currently entered them manually which are shaded bold on the left hand side. The formula would recognise that there is a record and pick up the field heading and put them on the left hand sided rather than me having to key them in manually. If there is no record, then it would return nothing/blank. please the layout of my report at work appears as exactly as shown above

I would be very grateful, if someone could please help me on this, as this would save me hours.


Thanks

msg500

 

[Telindarr]

If your last entry, Bikes Ducati 5 is in cell A8, then use this formula in cell A9: =IF(B9="","",A8)

The format would need to be: "Bikes" in cell A8, then "Ducati 5" in B8, then enter the formula in A9 and enter a record in B9.

Let me know if this is what you are looking for.

Tel.

 

[msg500]

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]Cars[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cars[/TD]
[TD][/TD]
[TD][/TD]
[TD]escort[/TD]
[TD]50[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cars[/TD]
[TD][/TD]
[TD][/TD]
[TD]focus[/TD]
[TD]20[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Bikes[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Bikes[/TD]
[TD][/TD]
[TD][/TD]
[TD]triumph[/TD]
[TD]10[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Bikes[/TD]
[TD][/TD]
[TD][/TD]
[TD]ducatti [/TD]
[TD]5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Apologies, this is what the example should look like. Is there a formula to repeat the field headings cars and bikes on the left hand side. I have currently entered them manually which are shaded bold on the left hand side. The formula would recognise that there is a record and pick up the field heading and put them on the left hand sided rather than me having to key them in manually. If there is no record, then it would return nothing/blank. please the layout of my report at work appears as exactly as shown above

I would be very grateful, if someone could please help me on this, as this would save me hours.

Thanks