# Transpose vs Pivot

The Tabular Transformation BizApp includes a Transpose Command that allows a the data set of delimited file to be rotated along the vertical or horizontal axis. The Transpose Command performs this action across all fields of the data set. This is not to be confused with a pivot action which rotates a single field along the vertical or horizontal axis. A Pivot Command is planned for a future release

Below is an example of the result of the Transpose Command.

*Raw data before Command*

*Data after Command*

Mike StaibDo you know when Pivot might be an option? Is there is a way I can accomplish turning multiple columns into a "measure" column and a data column?

Fld1,Fld2,Fld3,Col1,Col2,Col3,Col4,Col5,Col6,Col7

A, B, C, 1, 2, 3, 4, 5, 6, 7

X, Y, Z, 2, 4, 6, 8, 10, 12, 14

=====>

Fld1,Fld2,Fld3,Measure,Data

A, B, C, Col1,1

A, B, C, Col2,2

A, B, C, Col3,3

A, B, C, Col4,4

A, B, C, Col5,5

A, B, C, Col6,6

A, B, C, Col7,7

X, Y, Z, Col1,2

X, Y, Z, Col2,4

X, Y, Z, Col3,6

X, Y, Z, Col4,8

X, Y, Z, Col5,10

X, Y, Z, Col6,12

X, Y, Z, Col7,14

Tony ScaleseMike,

Advanced Query can be used for this until we provide a Command. See an example based on your sample data: