mike1984
10-08-2015, 08:02 AM
Hi all,
I have a database which has order numbers as rows and departments as columns, with the value of items as the data.
I am looking to sum up the value of items where two particular departments were shopped in the same transaction.
I have attached an example of the data (left hand matrix) and the result I would like (right hand matrix).
Hopefully the spreadsheet will help to explain better than I can! :)
Thanks
Mike
I have a database which has order numbers as rows and departments as columns, with the value of items as the data.
I am looking to sum up the value of items where two particular departments were shopped in the same transaction.
I have attached an example of the data (left hand matrix) and the result I would like (right hand matrix).
Hopefully the spreadsheet will help to explain better than I can! :)
Thanks
Mike