Dear all,
I have a data below
Branch Account code Account Name Months Sales
AYLESBURY H01371 XYZ Limited 2013-06 100
AYLESBURY H01371 XYZ Limited 2013-07 200
AYLESBURY H01371 XYZ Limited 2013-08 150
POOLE h01371 ABC Co. 2013-07 400
POOLE h01371 ABC Co. 2013-08 500
POOLE h01371 ABC Co. 2013-06 700
when I use pivot table and group by branch,account code and Account name it give only two records but both have H01371.
I want two record, one should be H01371 and second h01371.
How to separate both upper & lower case?
See attachment.
Please help!
Regards
Vinay
Bookmarks