Forum Discussion

Spigaw's avatar
Spigaw
Helper III
4 years ago
Solved

Pivoting a full table for a mailing project

Hello dear problem squashers,   I have to solve this situation where I have a classic database with as many rows as yearly situations per registration number. In order to be able to use it with Wor...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    First, unpivot all except the first two columns.

    Merge the Year and Attribute into a single column

    Then pivot the merged column to get the desired result.

     

AlexisOlson's avatar
AlexisOlson
Super User
4 years ago

First, unpivot all except the first two columns.

Merge the Year and Attribute into a single column

Then pivot the merged column to get the desired result.

 

  • Spigaw's avatar
    Spigaw
    Helper III
    4 years ago

    I don't have any comment, except that it works flawlessly.

    Thank you so much!