Do i look like an attention seeker and made a fool of myself?

I am sorry that you have been so upset by this experience. I shouldn't worry about how you came across to the consultant. The consultant will have seem many people in tears, angry, confused and a whole range of other emotions and so will not be phased by it. He/she probably wanted to be aware of your reason for changing so that they could explore that with you, help you or perhaps to avoid duplicating whatever was said that prompted you to change. Just because you are asked why you transferred, you do not have to answer. Next time you go along, try to forget about this first meeting. Maybe write down some things to ask before you go, so you can stay on track and make the meeting as useful as possible to you. Good luck.