Solved

pivot table rows into columns

Forum|Forum|5 years ago
March 10, 2020
3 replies
67 views

woody
5 replies

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

Best answer by ebygomm

AttributeExploder

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.