{{indexmenu_n>7}}
====== Column Reorder ======

The process step **Column Reorder** does exactly what its name says. It solves a common problem when the source data has a different structure than the target data. In this simple step you can reorder the columns avoiding long and tedious copying and pasting column-by-column.

There are four parameters that are required to be filled when using this process step:
  * **Source worksheet Djeeni name**: The Djeeni name of the source worksheet (the worksheet we want to copy the columns from)
  * **Source columns**: Column letters referring to the source worksheet, separated by semicolon character (A;C;B)
  * **Target worksheet Djeeni name**: The Djeeni name of the target worksheet (the worksheet we want to paste the columns to)
  * **Target columns**: Column letters referring to the target worksheet, separated by semicolon character (A;B;C)

The columns are copied from source to target worksheet in the order they are specified within the **Source columns** and **Target columns** parameters, to the same positions. If there is a B column specified on the third position (A;C;B) in the **Source columns** parameter, and the C column is specified on the third position (A;B;C) in the **Target columns** parameter, the B column from the source worksheet will be copied to the C column in the target worksheet.

|  1  |  2  |  **3**  |
|  A  |  C  |  **B**  |
|  A  |  B  |  **C**  |

Example: Take the columns A, C and D from the source worksheet and copy source column A to target column D; source C to target A; and source D to target C.  

{{ :en:process_steps:range_cell:columnreorder.png?nolink&400 |}}