Skip to main content
Solved

pivot table rows into columns

W
Forum|alt.badge.img

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

View original
    Did this help you find an answer to your question?

    3 replies

    ebygomm
    Influencer
    Forum|alt.badge.img+31
    • ebygommInfluencer
    • Influencer
    • Best Answer
    • March 10, 2020

    AttributeExploder

    W
    Forum|alt.badge.img
    • woody
    • Author
    • March 10, 2020
    ebygomm wrote:

    AttributeExploder

    thanks you

    M
    Forum|alt.badge.img+2

    @woody just for completeness - here is another example of a table transpose in case others find this question: Transpose a Table Using FME

    Reply


    Helpful Members This Week

    Community Stats

    30,942
    Posts
    117,257
    Replies
    38,742
    Members

    Latest FME

    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings
    A product of
    Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.