Prev: add two cells from seperate work sheets into a cell on seperat
Next: Significant digit causing wrong value?
From: G. on 20 May 2010 12:12

Hi,
I have used Pivot table and it only shows those 3 values in vertical way (1
column)..but i want the values to be shown horizontally (3 columns). Do you
know if Pivot table can do that?

Thanks,
G.



"ozgrid.com" wrote:

> Use a PivotTable
> http://www.ozgrid.com/Excel/excel-pivot-tables.htm
>
>
>
> --
> Regards
> Dave Hawley
> www.ozgrid.com
> "G." <G.(a)discussions.microsoft.com> wrote in message
> news:CA004410-908E-40D4-B1AF-1D51CBA33A4E(a)microsoft.com...
> > Hi I actually have another similar problem, can you help me?
> >
> > Hi I actually have a similar problem. Could you help me: Basically. I want
> > to look up number 222222 in column A, and have it returns 3 values from
> > column B which are 666666, 777777, and 9999999 in 3 separate column.
> > Please
> > help!
> >
> >
> > 1....................A....................B
> > 2..............123456...............1111111
> > 3..............222222...............6666666
> > 4..............222222...............7777777
> > 5..............222222...............9999999
> > 6..............444444...............8888888
>
> .
>
From: Roger Govier on 24 May 2010 05:00
Hi

Drag B to the Column area
--
Regards
Roger Govier

G. wrote:
> Hi,
> I have used Pivot table and it only shows those 3 values in vertical way (1
> column)..but i want the values to be shown horizontally (3 columns). Do you
> know if Pivot table can do that?
>
> Thanks,
> G.
>
>
>
> "ozgrid.com" wrote:
>
>> Use a PivotTable
>> http://www.ozgrid.com/Excel/excel-pivot-tables.htm
>>
>>
>>
>> --
>> Regards
>> Dave Hawley
>> www.ozgrid.com
>> "G." <G.(a)discussions.microsoft.com> wrote in message
>> news:CA004410-908E-40D4-B1AF-1D51CBA33A4E(a)microsoft.com...
>>> Hi I actually have another similar problem, can you help me?
>>>
>>> Hi I actually have a similar problem. Could you help me: Basically. I want
>>> to look up number 222222 in column A, and have it returns 3 values from
>>> column B which are 666666, 777777, and 9999999 in 3 separate column.
>>> Please
>>> help!
>>>
>>>
>>> 1....................A....................B
>>> 2..............123456...............1111111
>>> 3..............222222...............6666666
>>> 4..............222222...............7777777
>>> 5..............222222...............9999999
>>> 6..............444444...............8888888
>> .
>>
First  |  Prev  | 
Pages: 1 2
Prev: add two cells from seperate work sheets into a cell on seperat
Next: Significant digit causing wrong value?