I'm sure there is a very simple answer to this but I can't figure it out...
I have a table containing data about a new database that I am creating
It contains a list of mappings including the following columns
Code:
SourceValue, NewTable, NewField, NewFieldDescription, AnyOtherCol
a, Table1, Field1, blah 1, x
b, Table1, Field2, blah 2, x
c, Table2, Field1, blah 3, x
d, Table1, Field1, blah 1, x
A SourceValue can be mapped to a single table/field combination.
The table/field combination may however map to multiple SourceValues.
I want to create a table that will count the instances of each mapping but will also include in each row the NewFieldDescription, i.e. as follows:
Code:
NewTable, NewField, NewFieldDescription, Count of SourceValue
Table1, Field1, blah 1, 2
Table1, Field2, blah 2, 1
Table2, Field1, blah 3, 1
I can successfully create the pivot table without the description as follows:
Row Labels: NewTable, NewField
Values: Count of AnyOtherCol
But I don't know how to include the NewFieldDescription against each row in the table.
I'm using Excel 2007.