Following is extract from a pivot. All Centre IDs are related to 67210. I
want to show 67210 in each line


Account Centre ID Deptt 1 Deptt 2 Grand Total
67210 2110 0.06 0.06
6015 278.35 278.35
6999 (30.54) (30.54)
8010 131.67 131.67

Hi,
you can copy the value down, if you have different numbers you can use a
formula like the following, I assume that 67210 is in cell A2, and your
formula in D2 so D2 enter

=if(A2<"",A2,D1)

copy formula down

"walrus" wrote:

Following is extract from a pivot. All Centre IDs are related to 67210. I
want to show 67210 in each line


Account Centre ID Deptt 1 Deptt 2 Grand Total
67210 2110 0.06 0.06
6015 278.35 278.35
6999 (30.54) (30.54)
8010 131.67 131.67