---
schema_version: "1"
id: 763412ba8c071eedeb40ad684d1ecd5100ba76cdc899f6f9386921fd964d8998
title: MDP Apply Transpose Transformers
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/mcidp_data_streams_tc_transformers_transpose_apply.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.mcidp_data_streams_tc_transformers_transpose_apply.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: f89d43625e9e5ace3c6de3b092cb3d53a777abad5d4a3f22568a4184375fcf90
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"
---
# MDP Apply Transpose Transformers

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

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. Navigate to the **Import** tab.
2. Expand **Data Streams List**.
3. Create a data stream, or edit an existing one.
4. In the **Preview Source** screen, click **Edit Transformers**.
5. 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.
6. Define the details:
    
    ![Set details for transpose transformer](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-mktg-mcidp-264-0-0-production-enus/6ea21a7c-b623-43b5-9bb1-3174d8e8301e/mcidp/images/data_streams_transf_transpose.png)
    
    - **Start Column (1)** — 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.
    - **End Column (2)** — 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. )
    - **Group Size (3)** — 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.
    - **Whole words transpose (4)** — 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.
    - **Keep header value as is (5)** — 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.
7. Click **Done**.

Here’s what the table looks like after transpose:

![Table after transpose applied](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-mktg-mcidp-264-0-0-production-enus/6ea21a7c-b623-43b5-9bb1-3174d8e8301e/mcidp/images/data_streams_trans_after_transpose.png)