Moving data from column to row

Closed
pramoth Posts 1 Registration date Friday 24 January 2014 Status Member Last seen 24 January 2014 - 24 Jan 2014 à 03:00
 pramoth - 30 Jan 2014 à 02:38
Hi All,

Please help me with the macro code for pasting the column data(which is shown below) to row.

Data is have like this

A Cell B Cell
1 Working Time :8.30 AM TO 5.30 PM
2 19
3 Branch: Mannar - Parumala (Code: 2278)
4 Mannar - Parumala
5 Building No. V/419A, Nasreen Building, Ist Floor, Mannar-Parumala Junction,
6 Opp. Federal Bank, Alapuzha Dt.,
7 Pin - 689 622
8 Ph : 0479 - 2311020

Need data in below format
A B C D
Working Time :8.30 AM TO 5.30 PM 19 Branch: Mannar - Parumala (Code: 2278) Mannar - Parumala

E
Building No. V/419A, Nasreen Building, Ist Floor, Mannar-Parumala Junction, Opp. Federal Bank, Alapuzha Dt.,

F G
Pin - 689 622 Ph : 0479 - 2311020

In the above row form i need the details.Can anyone help me on this pls.

1 response

venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
25 Jan 2014 à 00:23
what is the need for row no. 4
pain to transfer to excel sheet

save your data sheet in excel
upload this fille to
speedyshare.com
copy paste the url of uploaded file and explain what you want.
Hi venakt,
I have upload the sample excel file in the website(speedyshare.com) you have provided.Please check and let me know the solution.
Down Link:http://speedy.sh/neunB/Requirement.xls
HTML Link:<a href="http://speedy.sh/neunB/Requirement.xls">Download at SpeedyS