|  | Changing the Dataset. | | |
| | | SD |  |
|  Posted: Mon Jun 30, 2008 2:29 pm Post subject: Changing the Dataset. |  |
Hello All,
I have the following data set coming out of a pivot.
Name 2006 2007
A 23 65
24 56
5 34
B 33 45
66 23
45 56
How can I get it in the following format in excel.
Year Name number
2006 A 23
2006 A 24
2006 A 5
2006 B 33
2006 B 66
2006 B 45
2007 A 65
2007 A 56
2007 A 34
2007 B 45
2007 B 23
2007 B 56
Many thanks
SD |
| |
| | | Roger Govier | |
| | Posted: Mon Jun 30, 2008 3:55 pm Post subject: Re: Changing the Dataset. | |
Hi
From Debra Dalgleish's site -
The row headings show once in a Pivot Table, and there's no setting you can
change, to force them to repeat.
To create a table with a heading on each row, you could copy the pivot
table, paste it as values in another location,
and fill in the blanks, using the technique shown here:
LINK .
--
Regards
Roger Govier
"SD" <saurabhkdas@gmail.com> wrote in message
news:d16433ab-222e-45d6-8949-514907d461aa@x35g2000hsb.googlegroups.com...
| Quote: | Hello All,
I have the following data set coming out of a pivot.
Name 2006 2007
A 23 65
24 56
5 34
B 33 45
66 23
45 56
How can I get it in the following format in excel.
Year Name number
2006 A 23
2006 A 24
2006 A 5
2006 B 33
2006 B 66
2006 B 45
2007 A 65
2007 A 56
2007 A 34
2007 B 45
2007 B 23
2007 B 56
Many thanks
SD |
|
| |
| | | ShaneDevenshire | |
| | Posted: Mon Jun 30, 2008 8:09 pm Post subject: RE: Changing the Dataset. | |
Hi SD,
Don't give up quite so quickly there are solutions however your sample pivot
table layout appear very strange:
Why do you have 3 lines for 2006 A? Excel would collapse those into one
line if those are the only two conditions.
Could you show us some sample data.
--
Thanks,
Shane Devenshire
"SD" wrote:
| Quote: | Hello All,
I have the following data set coming out of a pivot.
Name 2006 2007
A 23 65
24 56
5 34
B 33 45
66 23
45 56
How can I get it in the following format in excel.
Year Name number
2006 A 23
2006 A 24
2006 A 5
2006 B 33
2006 B 66
2006 B 45
2007 A 65
2007 A 56
2007 A 34
2007 B 45
2007 B 23
2007 B 56
Many thanks
SD
|
|
| |
| | | SD | |
| | Posted: Tue Jul 01, 2008 8:24 am Post subject: Re: Changing the Dataset. | |
Shane : 3 rows of data?. Yes it has 3 rows of data.. I have taken off
the subtotals . And A and B are formulas created in the pivot .
many thanks Roger and Shane for your replies.
thanks
SD |
| |
|
|
