Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
en:process_steps:range_cell:columnreorder [2020/03/12 14:39] andraz |
en:process_steps:range_cell:columnreorder [2024/02/24 23:38] (current) tiger |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | {{indexmenu_n> | ||
| ====== Column Reorder ====== | ====== Column Reorder ====== | ||
| Line 9: | Line 10: | ||
| * **Target columns**: Column letters referring to the target worksheet, separated by semicolon character (A;B;C) | * **Target columns**: Column letters referring to the target worksheet, separated by semicolon character (A;B;C) | ||
| - | {{djeeni:column_reorder.png}} | + | 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: | ||