Hi

 

 

i'm trying to pivot (transpose) some data, but all the examples i can find on here turn rows into columns, and i want to turn columns into rows.

 

 

DATA

 

 

 

RegionUnder 1616-1718-1920-2425-3435-4445 and overDurham572025263520Darlington351827284425Gateshead8152535262835

 

what i want it to look like

 

RegionAge BandValueDurhamUnder 165Durham

 

16-177Durham18-1920Durham

 

20-2425Durham

 

25-3426Durham

 

35-4435Durham

 

45 and over20DarlingtonUnder 163Darlington16-175Darlington18-1918Darlington20-2427Darlington25-3428Darlington35-4444Darlington45 and over25

 

etc.

 

Any help in much appreciated.

 

Thanks

Mark