Changing the Dataset.

[SD]

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]

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:
http://www.contextures.com/xlDataEntry02.html .

 

[ShaneDevenshire]

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.

 

[SD]

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