PivotTable - Repetition of rows
 

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.

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