LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Flipping Cell Data Horizontal/Vertical

Hello,

I hope I can describe this correctly to see if there is an Excel macro
already available:

Is there a function or macro that can take a set of cells and "flip"
it so that it runs perpendicularly to its original orientation? For
example, if one has values in column A1 through A5, this macro would
allow you to select that data, run the macro, and the resulting data
would then appear in cells A1 through E1. (The reverse would also be
possible.) This would help avoid having to retype, say, query column
headers imported into Excel if one wanted those header names to run
vertically instead of horizontally.

Thanks in advance for any help.

Regards,
Shepherdmoon
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
moving data from vertical to horizontal possition leo Excel Worksheet Functions 4 April 28th 08 09:08 PM
Cross Reference Vertical and Horizontal for Data Kev - Radio Man Excel Worksheet Functions 4 March 24th 08 04:02 PM
Need lookup of data both vertical and horizontal rmargh Excel Discussion (Misc queries) 2 November 21st 07 05:10 PM
How to make Horizontal data go Vertical tx12345 Excel Worksheet Functions 10 December 24th 05 03:40 AM
tranfere vertical data to horizontal tabel dagfinn Excel Worksheet Functions 2 January 29th 05 06:19 PM


All times are GMT +1. The time now is 02:27 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"