Moving data from column to row [Closed]

Report
Posts
1
Registration date
Friday January 24, 2014
Status
Member
Last seen
January 24, 2014
-
 pramoth -
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 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
791
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!