I have looked high and low for product that will meet a need that I often have; from the number of posts that I find on the net many others have as well.

More and more, with the increase in the amount of data being collected and queried, data warehouses, BI software, using columnar tables (sometimes referred to as a vertical data structure) makes more since. Vertica DB and Terri Data use this structure natively.

However, it often is necessary to convert (or pivot) the data to a traditional horizontal, row-based format. In SQL Server as well as Oracle, and others I assume, this requires writing code which can be laborious and a real pain. A product or feature that offers the capability to quickly configure and pivot a vertical structured table is much needed. thanks for your consideration