Forum Discussion
Pivot not reading text data from external source
I have some data that contains text and numbers (marca column). When showing marca in a pivot (file section) that is read from same file, all data is displayed. When showing marca in a pivot (file ...
Siegfried,
try changing the data in marca column to only one data type (either text or number).
Hi Detlef.
I changed format, first to number, and no changes on file 2.
Then I changed format to text and finnally I got all data, however, I cannot sort it as numbers.