Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Alternating BG colors between groups of rows | Excel Discussion (Misc queries) | |||
PivotTable and Chart | Excel Discussion (Misc queries) | |||
Dynamic parameterized PivotTable update? | Excel Discussion (Misc queries) | |||
Automatically inserting rows | Excel Worksheet Functions | |||
Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) |