I am having issues with the bulk download member data csv
Here's an example from my file today where everything is in DD/MM/YYYY format:
In other parts of the sheet the data is aligned left or right:
I am working with Google Sheets and trying to sort the data by month/date/year but I can't transform the date format into month first.
Also incidentally there is the empty row below the header row which is very irritating.
Anyone working in Google sheets with any tricks to transform this data quickly with a formula to get it all into the right format. I've exhausted the Custom Date Format options and checked all my systems settings are in the desired output date for MM/DD/YYYY
Welcome to the Technology board!Curious about our platform? Looking to connect on social technology? You've come to the right place!