Thanks
Unfortunatelly the column values are not numerical.
Debra Dalgleish Wrote:
If the columns contain numbers, you could insert a new column, titled
DQ_errors, and sum the data in all the DQ_error columns.
Then, use the new column in the pivot table.
Portuga wrote:
Hi,
I get a report produced by another application in an excel
spreadsheet
and
I am trying to do a pivot table from this report.
In this spreadsheet I have the (partial) following columns with the
headings:
Column a; Column b; Column c; Column d; Column e;
Acc_no; Srce_sys; DQ_error; DQ_error;
DQ_error;
- - - -
-
- - - -
-
- - - -
-
- - - -
-
My problem is the following:
If I do a pivot from this information, each column will be a field
in
the pivot.
I want columns C, D and E to be just one field, because they all
represent the heading "DQ_error". Is it possible to "merge" these 3
columns so they can be just one field in the pivot.
I know I could do a lot of copying and pasting but in the report
there
are about 19 columns with the heading DQ_error so I'm trying to
avoid
that.
Thanks
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html
--
Portuga
------------------------------------------------------------------------
Portuga's Profile:
http://www.excelforum.com/member.php...fo&userid=6385
View this thread:
http://www.excelforum.com/showthread...hreadid=566951