Moving data from column to row

Closed
pramoth Posts 1 Registration date Friday January 24, 2014 Status Member Last seen January 24, 2014 - Jan 24, 2014 at 03:00 AM
 pramoth - Jan 30, 2014 at 02:38 AM
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 June 14, 2009 Status Contributor Last seen August 7, 2021 811
Jan 25, 2014 at 12:23 AM
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