Using a pivot table is the perfect solution for a challenge I have, but I
will subsequently need to mechanically refer to values in the pivot field,
but because they don't repeat, there is no value in most rows (just the
first occurrence for the current group. Ex. Date then hour...date shows
once, then each of the 24 hours)

I either need to repeat the pivot field value, or derive a way to refer to
the pivot value for the current group.

TIA for any help, regards.

Found the posts for repeating the value (previous searches didn't turn
anything up but that is ID10T error)

Would still direction on a way to remove the requirement to repeat the
values by directly referring to the group header value if possible.



"Rich" wrote:

Using a pivot table is the perfect solution for a challenge I have, but I
will subsequently need to mechanically refer to values in the pivot field,
but because they don't repeat, there is no value in most rows (just the
first occurrence for the current group. Ex. Date then hour...date shows
once, then each of the 24 hours)

I either need to repeat the pivot field value, or derive a way to refer to
the pivot value for the current group.

TIA for any help, regards.