By Sheila Zhang

GLAFS table is my favorite data table in the Sage 300 ERP database. It was designed to list all fiscal periods of a fiscal year with 15 fields or columns. Here are two ways to transpose the period’s columns to rows.

Method 1:

Method 2:

For further details of UNPIVOT function, please click here.

This is what the results from both statements look like: