---
schema_version: "1"
id: 6d09b235d438f8f23cd2bc1ff6956544d08063a500c6527dd3e70c7ed5b1a2ac
title: Apply Transpose Transformers
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/dato_data_streams_tc_transformers_transpose_apply.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.dato_data_streams_tc_transformers_transpose_apply.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 3f3c49ae065288f027fa53d91b856de4cd62f9ce234ad3a62272f90a3a0de039
description: Apply a transpose transformer when you want to reconstruct a flat-file format by translating columns of data into rows.
products:
  - Marketing
  - Marketing Cloud Intelligence
release: "264"
---
# Apply Transpose Transformers

Apply a transpose transformer when you want to reconstruct a flat-file format by translating columns of data into rows.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:center;vertical-align:top;" id="d63535e38">User Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d63535e38 ">To apply transformers:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d63535e38 ">Admin</td>

          </tr>
        </tbody>
      </table>

If headers in your file look like this, and you want to transpose View Through Conversions and Click Through Conversions into separate rows, this example shows how to apply a transpose transformer:

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
        <colgroup>
          <col style="width:12.5%">
          <col style="width:12.5%">
          <col style="width:12.5%">
          <col style="width:12.5%">
          <col style="width:12.5%">
          <col style="width:12.5%">
          <col style="width:12.5%">
          <col style="width:12.5%">
        </colgroup>
        <tbody>
          <tr class="">
            <td class="slds-cell-wrap" style="vertical-align:top;">Date</td>

            <td class="slds-cell-wrap" style="vertical-align:top;">Campaign</td>

            <td class="slds-cell-wrap" style="vertical-align:top;">Activity 1 View Through Conversions</td>

            <td class="slds-cell-wrap" style="vertical-align:top;">Activity 1 Click Through Conversions</td>

            <td class="slds-cell-wrap" style="vertical-align:top;">Activity 2 View Through Conversions</td>

            <td class="slds-cell-wrap" style="vertical-align:top;">Activity 2 Click Through Conversions</td>

            <td class="slds-cell-wrap" style="vertical-align:top;">Activity 3 View Through Conversions</td>

            <td class="slds-cell-wrap" style="vertical-align:top;">
              <p style="margin-bottom:0;">Activity 3 Click Through Conversions</p>
            </td>

          </tr>
          <tr class="">
            <td class="slds-cell-wrap" style="vertical-align:top;">08-14-15</td>

            <td class="slds-cell-wrap" style="vertical-align:top;">ABC_FY15</td>

            <td class="slds-cell-wrap" style="vertical-align:top;">10</td>

            <td class="slds-cell-wrap" style="vertical-align:top;">4</td>

            <td class="slds-cell-wrap" style="vertical-align:top;">100</td>

            <td class="slds-cell-wrap" style="vertical-align:top;">20</td>

            <td class="slds-cell-wrap" style="vertical-align:top;">43</td>

            <td class="slds-cell-wrap" style="vertical-align:top;">
              <p style="margin-bottom:0;">31</p>
            </td>

          </tr>
        </tbody>
      </table>

1. From the **Connect & Mix** tab, select **Data Streams**, and then **Data Streams List**.
2. Create a data stream, or edit an existing one.
3. In the **Preview Source** screen, click **Edit Transformers**.
4. Transpose transformers aren’t added by default, so you must add them. In the **Add Transformers** area, next to the **Transpose Transformer**, click the blue plus icon.
5. Define the details:
    
    ![Set details for transpose transformer](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-mktg-salesforce_datorama-264-0-0-production-enus/d38a342d-dd4a-4af8-8343-f372280a75dd/salesforce_datorama/images/data/data_streams_transf_transpose.png)
    
    <table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small "><tbody><tr class=""><td class="slds-cell-wrap"><strong class="uicontrol">Start Column</strong> (1)</td><td class="slds-cell-wrap">Sets the column that you want to start the transpose from, meaning the first column with the dimension and measurements together in the header. In this case, set to Activity 1 View Through Conversions.</td></tr><tr class=""><td class="slds-cell-wrap"><strong class="uicontrol">End Column</strong> (2)</td><td class="slds-cell-wrap">Sets the column where you want to stop the transpose. The column specified isn’t transposed. When using this option, don’t map the non-transposed measurements because doing so causes the data to be duplicated. (This option isn’t the default. In most files, it isn’t necessary to stop the transpose process. )</td></tr><tr class=""><td class="slds-cell-wrap"><strong class="uicontrol">Group Size</strong> (3)</td><td class="slds-cell-wrap">Sets the number of columns relevant to the same dimension value. Set the group size throughout the file, otherwise you risk linking measurements to the wrong dimension values. If some columns are missing, you receive the "Transpose groups are incomplete" error and can’t continue to the mapping screen. In this case, set the group size to 2 because you’re creating two groups.</td></tr><tr class=""><td class="slds-cell-wrap"><strong class="uicontrol">Whole words transpose</strong> (4)</td><td class="slds-cell-wrap">If you want to transpose whole words, select this option. If there are repeating words, they must have a space before and after them. This option doesn’t split words when creating the transpose object dimension.</td></tr><tr class=""><td class="slds-cell-wrap"><strong class="uicontrol">Keep header value as is</strong> (5)</td><td class="slds-cell-wrap">After locating the repeating words in the group, the transpose creates the transpose object dimension so that it includes the entire column header without separating the measurement section. When there are groups of more than one column, the value that appears as the dimension is the first value in the group. This option isn’t a default, and it’s used to transpose columns of dates. This way, the year, which is a repeating word, isn’t separated from the rest of the date. For example, if you want to transpose dates 01-01-2020 and 01-02-2020, select this checkbox.</td></tr></tbody></table>
6. Click **Done**.

Here’s what the table looks like after transpose:

![Table after transpose applied](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-mktg-salesforce_datorama-264-0-0-production-enus/d38a342d-dd4a-4af8-8343-f372280a75dd/salesforce_datorama/images/data/data_streams_trans_after_transpose.png)