PivotTable - Repetition of rows
Maybe you can concatenate all the important fields into one in the raw data:
=a2&"-"&b2&"-"&text(c2,"mm/dd/yyyy")&"-"&d2
and use that in your pivottable.
If you use a fixed width font like courier new, you could pad each field with
spaces:
=left(a2&Rept(" ",15),15) & "-" & ....
It might look more like a table.
sailor-1 wrote:
Can anyone suggest how I could get rid of multiple rows for each data
element? I have multiple attribute fields (brought in as PivotTable rows)
each of which is currently taking its own row which is wasteful.
I would like all associated data to appear on a single row with the
summation (the "data" element) at the end.
--
Dave Peterson
|