reverse a pivot back to original data state

X

xlnewbie

Can data created with a pivot table be reversed? I have a table that i
currently in the following format:

Place Name Area1 Area2
Area3...etc
London Abby 25 44 52
Birmingham John 1 22 3
Westham Fred 22 2 4

I want to convert it to the following

Place Name Area Total
London Abby Area1 25
London Abby Area2 44
London Abby Area3 52
Birmingham John Area1 1
Birmingham John Area2 1
Birmingham John Area3 1
Westham Fred Area1 22

My Areas which are currently the column headers go up to 'DP'

Is this a massively difficult taks? I have tried everything, and othe
than manually going through and adding the dat, cant think of how els
to do it.

Any help/ guidance would be greatly appreciated:confused
 
X

xlnewbie

Thanks Frank

you are a hero!

It worked and I am well pleased - saved hours of work!!
 
Top