Jan 12 2023 10:51 AM
Since excel pivot tables are case insensitive it will keep only one text value when multiple have different cases. Does anyone know the logic on how a final text value is decided? For example, what would excel pick between 'Name', 'NAME'
Jan 12 2023 12:24 PM
It simply picks the first instance that it encounters (reading from top to bottom).