Thread: Make row in one sheet equal column of another
View Single Post
 
Old 03-23-2010, 03:52 PM
ConneXionLost's Avatar
ConneXionLost ConneXionLost is offline Windows XP Office 2003
Simulacrum
  
Join Date: Jan 2010
Location: Victoria, Canada
Posts: 86
ConneXionLost is on a distinguished road
Default
Hi,

The simplest solution would be to highlight your 'complaint index' range, select copy, then move to your other sheet, select the first cell of your destination column, and use "Paste Special..." with "Transpose".

If you need a formula, please identify the size of the source range and the first cell of your destination column.

Cheers,
Reply With Quote