pivot table with upper case and lower case

[ericlch16]

Hi

I have this as data in column A , B to create a pivot

test 1
Test 1
Test 1


When I do a pivot it returns on the data above it returns only 1 line as

test 3

(3 is the total)

'*************************************
Is there anyway the pivot returns ?

test 1
Test 2

 

[Joe4]

Pivot tables are not case sensitive in Excel. That is just the way they work.
If you need to segregate them, you will need to do some workarounds.
A few ideas are mentioned here: https://www.pcreview.co.uk/threads/pivot-tables-case-sensitive-grouping.2741726/