 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2008flip columns to rows
Is there any way to 'flip' a worksheet with one command, so that columns become rows (or rows become columns)? Have you tried the Transpose function? > Is there any way to 'flip' a worksheet with one command, so that columns become > rows (or rows become columns)? >Is there any way to 'flip' a worksheet with one command, so that columns become >rows (or rows become columns)? Not one command, but you could write a macro. Select all Copy Paste Special tick "Transpose" Chris  SignatureChris J Dixon Nottingham UK chris@cdixon.me.uk Have dancing shoes, will ceilidh. > Is there any way to 'flip' a worksheet with one command, so that columns > become > rows (or rows become columns)? Copy Paste Special ..... transpose AndyW > Is there any way to 'flip' a worksheet with one command, so that columns become > rows (or rows become columns)? Another way, via a formula Assume source data in Sheet1 In Sheet2, Put in A1: =OFFSET(Sheet1!$A$1,COLUMNS($A:A)-1,ROWS($1:1)-1) Copy A1 across & fill down as far as required to return a dynamic transpose of Sheet1 SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- Much easier formula (I'm using in that case) on the sheet2 in A1: = OFFSET(Sheet1!$!$1,COLUMN()-1;ROW()-1) This is one common "fault" - people forget the most simple 2 functions - ROW() and COLUMN() With offset they may do the miracles :) With bests >> Is there any way to 'flip' a worksheet with one command, so that columns >> become [quoted text clipped - 7 lines] > transpose > of Sheet1 Albeit longer, the earlier version was meant to be a generic which could be placed in any starting cell in Sheet2 and then propagated across/down, in case this is preferred. SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik ---
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.