Differences

This shows you the differences between two versions of the page.

--- en:process_steps:range_cell:columnreorder [2020/03/13 09:47]
andraz
+++ en:process_steps:range_cell:columnreorder [2024/02/24 23:38] (current)
tiger
@@ Line 1: / Line 1: @@
+{{indexmenu_n>7}}
 ====== Column Reorder ======
@@ Line 11: / Line 12: @@
 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.
-Example: Take the columns A to G from the source worksheet and put B before A in the target worksheet. All other columns stay in the same order.
+|  1  |  2  |  **3**  |
+|  A  |  C  |  **B**  |
+|  A  |  B  |  **C**  |
-{{djeeni:column_reorder.png}}
+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.
-| 1 | 2 | 3 | 4 | 5 | 6 | 7 |
+{{ :en:process_steps:range_cell:columnreorder.png?nolink&400 |}}
-| A | B | C | D | E | F | G |
-| B | A | C | D | E | F | G |