Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-09-2009, 06:37 AM
aligahk06 aligahk06 is offline Help swaping value from horizontal to vertical. Windows XP Help swaping value from horizontal to vertical. Office 2007
Advanced Beginner
Help swaping value from horizontal to vertical.
 
Join Date: Aug 2009
Posts: 58
aligahk06 is on a distinguished road
Default Help swaping value from horizontal to vertical.


Dear All,
I want to fetch data from horizontal to vertical .
Data format is c6:j6 total eight values c7:j7 upto c21 to j21 total 128
values.
This 128 values which was placed horizontal i want to pull it into
vertical col.
i.e Range C6:J6 into D1:D8 and C7:J7 into D9:D16 and so on till range
C21to J21 into D... :D ... vertical.
Please assist either macro or Function.

Rgds,
aligahk06
Reply With Quote
  #2  
Old 09-10-2009, 07:05 PM
zyzzyva57 zyzzyva57 is offline Help swaping value from horizontal to vertical. Windows 7 32bit Help swaping value from horizontal to vertical. Office 2007
Expert
 
Join Date: Mar 2009
Location: Dawsonville, Ga (NE of Atl)
Posts: 355
zyzzyva57 is on a distinguished road
Default

Does this do it for you:

Highlight what you want changed

Copy

Move your Cursor to where you want the data

Go to Paste Special, then select Transpose
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help swaping value from horizontal to vertical. In vertical allignment, the dif. bettwen Justify and Distributed? Philos Hippos Excel 2 10-28-2009 10:44 AM
Vertical justification wmws Word 0 03-25-2007 03:19 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:26 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft