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/13 09:48] 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 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. | 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 | | + | | 1 | 2 | **3** |
| - | | A | C | B | | + | | A | C | **B** |
| - | | A | B | C | | + | | A | B | **C** |
| - | Example: Take the columns A to G from the source worksheet and put B before | + | Example: Take the columns A, C and D from the source worksheet and copy source column |
| - | {{djeeni:column_reorder.png}} | + | {{ :en: |