Key field

[amiroh81]

Hello
I wish to cutting data according to a key field Can I do this?

for example:

i have those fields,

A                B                  C

-------------------------------------------

1              ZZZ               XXX

1              EEE             EEE

2              333               222

3              444               333

3              ZZZ               ZZZ

3              RRR             RRR

I Wont to Display the data like  (A field will be the key field):

A                B                  C

-------------------------------------------

1              ZZZ               XXX

1              EEE             EEE

________________________

2              333               222

________________________

3              444               333

3              ZZZ               ZZZ

3              RRR             RRR

thanks in advanced

Amir

[reshmakala]

Hello,

Is this what you are looking for?

[#3]

Would a pivot table solve your needs?

[amiroh81]

Hi,

That helpful.

At first I thought that but bothered me the sign of but i figured out how to download the mark.
Is it possible to BOLD the line between the groups?

Thanks in advanced

[avinashelite]

Pivot table will solve your needs, please go with that

[amiroh81]

And Another Another:

How can i Disappear the expression coluom in pivot table?

i dont need the expression

[reshmakala]

In my example, Go to the properties tab -> Expressions

Check the conditional option and put in 1=2 or any condition that is not true. This will hide the expression column in the pivot table. The result will be:

Hope that helps.