Hi there,
I have downloaded an Excel spreadsheet that is too large to open all the data. I have attempted to 'add data', but it appears there isn't an option where I can filter the only specific years I need from the data set. I saw online that 'Transform Data' is a thing , but it doesn't appear in my 'preview data' page before importing it. Why don't I have 'transform data'? I just updated my excel to excel 16.68.
I'm using MAC by the way. Thanks for reading my post, any help is appreciated!
I have downloaded an Excel spreadsheet that is too large to open all the data. I have attempted to 'add data', but it appears there isn't an option where I can filter the only specific years I need from the data set. I saw online that 'Transform Data' is a thing , but it doesn't appear in my 'preview data' page before importing it. Why don't I have 'transform data'? I just updated my excel to excel 16.68.
I'm using MAC by the way. Thanks for reading my post, any help is appreciated!