I am pulling data from the titles table of the Pubs database.
I get to see all the titles of the database. Now all the titles start with different letters. How can create a formula that will look only into the first letter of the title field and then show a different category for each letters. So all titles starting with A will fall under A
Something like below
So on and so forth...
Hope to hear more on this.