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.
0
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
0