Is the following given as one cell? 'from 2012-2013 did Course A in School B then from 2013-2014 did Course AD in Institution GG'
If so it will needed to be parsed out. Do you have an excel file with example data?
Thanks for your mail. Actually we are just about to collect the data, so that's why I asked how to enter this data in excel and then analyse it in tableau. So its like we can construct it from scratch.
I would review the following KB: http://kb.tableau.com/articles/knowledgebase/preparing-excel-files-analysis?lang=en-us
There is also a video to check out here: http://www.tableau.com/learn/tutorials/on-demand/data-prep-text-and-excel-files?signin=1eb52dd155da7ef36c869b41e8c54a9b
The above links should help.