Thread: Images inside . . I need to Flip Columns, to Rows & Visa Versa?? SIMPLE RIGHT? :(
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
mrice mrice is offline
external usenet poster
  
Posts: 1
Default Images inside . . I need to Flip Columns, to Rows & Visa Versa?? SIMPLE RIGHT? :(

If you past the following into cell C1

=INDIRECT("A" & 1+(12 *(INT((CELL("Row",C1)-1)))+CELL("Col",C1)-3))

and copy the formula across the 11 columns to the right and then all 12
cells in the row down as far as you need, you should get what you want.


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=560771

Reply With QuoteReply With Quote