R
Rich
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.
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.