How to change data from horizontal to vertical in excel

How to change data from horizontal to vertical in excel sheet
Please help me.
I have data in horizontal format in file A which i need to convert into Vertical layout in file B

The question sounds vague. An example would be helpful.