Automatic Pivot of column data
One request that we have had with the previous version of SQL Spreads is to be able to let the application save Excel data Pivoted into one column.
The most obvious example is to have a forecast model where forecast values are entered in one column per month and where the application then transpose the data in the monthly columns and stores all monthly values in one column but using twelve rows where each row has a key for the month.
1
vote
