Hi,
I'm having normal tables with numbers, names, years, months, days types for
example collecting a fruits and I need make some statistic, that who
everybody tough apples, how many apples were taken etc.
Basically it means, that I'm having from a1 to m1 first row, where are
written information about objects, which are in second, thirth etc. rows
from a to m.
And i need now making a table, where for example all
M fields will be in rows, all C fields will be as a columns and all fields
F will be a data field.
With best regards,
Marek Durila
IBM Global Services Delivery Center Czech Republic, s.r.o., Sídlo: Brno,
Technická 2995/21, PSC 61600
IC: 26244535, Zapsaná v obchodním rejstríku, vedeném Krajským soudem v Brne
oddíl C, vložka 39922
IBM Global Services Delivery Center Czech Republic, s.r.o., Registered
address: Brno, Technicka 2995/21, Zip code: 61600
Company ID: 26244535, Entered in the Commercial Register maintained by the
Regional Court in Brno (Part C, Entry 39922)
"Steve Jacobson"
<steve.jacob...@v
isi.com> To
"[email protected]"
11/11/2009 15:23 <[email protected]>
cc
Subject
Re: Pivot table?
I remember seeing your first note, but I think that most of us have
probably run into problems using the pivot table wizzard. I have attempted
it on several occasions
and found that I had to use the mouse keys and the results were not at all
consistent. That is probably why you are not getting answers on this. As
I recall, you can
look at the defining parameters of a pivot table after it has been created,
so the best short term solution might be to have someone set it up
visually. There might be
a way to create one manually without using the wizzard and there might also
be a scripting approach. If you could describe what you are wanting to do
with the
pivot table, we might be able to suggest alternatives.
Best regards,
Steve Jacobson
On Wed, 11 Nov 2009 14:39:02 +0100, Marek Durila wrote:
>Hi all,
>I didn't saw it in my in-box folder, in this Case I'm sending again.
>Do you have somebody any experiences with Pivot Table in Excel?
>How it's works, how can I go trough it?
>It used for a statistic or listing some necessary information, but it's
>everything, what I know about.
>Excel 2003 or XP is optional.
>I'm having classic table with 250 rows and 20 columns and I need some
>columns make as rows, some as a columns and some put in data field. I'm
>able go only trough vizard but what to do after?
>With best regards,
> Marek Durila
>IBM Global Services Delivery Center Czech Republic, s.r.o., SA-dlo: Brno,
>TechnickA 2995/21, PSC 61600
>IC: 26244535, ZapsanA v obchodnA-m rejstrA-ku, vedenAcm KrajskA«m soudem v
Brne
>oddA-l C, vlo_ka 39922
>IBM Global Services Delivery Center Czech Republic, s.r.o., Registered
>address: Brno, Technicka 2995/21, Zip code: 61600
>Company ID: 26244535, Entered in the Commercial Register maintained by the
>Regional Court in Brno (Part C, Entry 39922)
If you reply to this message it will be delivered to the original
sender only. If your reply would benefit others on the list and
your message is related to GW Micro, then please consider sending
your message to [email protected] so the entire list will receive it.
All GW-Info messages are archived at http://www.gwmicro.com/gwinfo, and can
be searched through and sorted using the search
form at the bottom of the page.
If you wish to unsubscribe from this list, send a message to
[email protected] and include leave gw-info in the body
of the message.
