Columns as Rows

[tpsstudent]

Hi, pretty new excel user and I was looking for a way to view columns as rows and vice versa without transposing the whole sheet.

I've tried transposing to two different worksheets and then linking but that process was slow and fraught with errors.

Is there any way to do this easily?
Anyone have any suggestions for lookups on the Excel website or Help, I've run out of ideas to look up

Thanks

[Ragdyer]

Say you want to take Column A, and display it along a row (*any* row),
Enter this in *any* cell, and drag across to copy:

=INDEX($A:$A,COLUMNS($A:A))

Say you want to take Row1, and display it down a column (*any* column),
Enter this in *any* cell, and drag down to copy:

=INDEX($1:$1,ROWS($1:1))

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"tpsstudent" <[email protected]> wrote
in message news:[email protected]...
>
> Hi, pretty new excel user and I was looking for a way to view columns as
> rows and vice versa without transposing the whole sheet.
>
> I've tried transposing to two different worksheets and then linking but
> that process was slow and fraught with errors.
>
> Is there any way to do this easily?
> Anyone have any suggestions for lookups on the Excel website or Help,
> I've run out of ideas to look up
>
> Thanks
>
>
> --
> tpsstudent
> ------------------------------------------------------------------------
> tpsstudent's Profile:
> http://www.excelforum.com/member.php...o&userid=36256
> View this thread: http://www.excelforum.com/showthread...hreadid=560500
>

[Ragdyer]

Excuse my clock!
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ragdyer" <[email protected]> wrote in message
news:%[email protected]...
> Say you want to take Column A, and display it along a row (*any* row),
> Enter this in *any* cell, and drag across to copy:
>
> =INDEX($A:$A,COLUMNS($A:A))
>
> Say you want to take Row1, and display it down a column (*any* column),
> Enter this in *any* cell, and drag down to copy:
>
> =INDEX($1:$1,ROWS($1:1))
>
> --
> HTH,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit !
> ---------------------------------------------------------------------------
> "tpsstudent" <[email protected]>
> wrote in message
> news:[email protected]...
>>
>> Hi, pretty new excel user and I was looking for a way to view columns as
>> rows and vice versa without transposing the whole sheet.
>>
>> I've tried transposing to two different worksheets and then linking but
>> that process was slow and fraught with errors.
>>
>> Is there any way to do this easily?
>> Anyone have any suggestions for lookups on the Excel website or Help,
>> I've run out of ideas to look up
>>
>> Thanks
>>
>>
>> --
>> tpsstudent
>> ------------------------------------------------------------------------
>> tpsstudent's Profile:
>> http://www.excelforum.com/member.php...o&userid=36256
>> View this thread:
>> http://www.excelforum.com/showthread...hreadid=560500
>>
>