iterative Macro From right column to left Column

Question

Hi

I have two datasets, I'm looking to build Iterative Macro, where expected output should pick from right to left column

h1h2h3h4product1   product2   product3sub1  product4sub2  product5sub3sub_1_1 product6sub4sub_1_2sub_2_1

hmappedsub_2_1asub_1_2bsub_1_1dsub2fsub4ksub3msub1o

Expected Output:

h1h2h3h4mproduct1    product2    product3sub1  oproduct4sub2  fproduct5sub3sub_1_1 dproduct6sub4sub_1_2sub_2_1a

binu_acs · Accepted Answer

@BRRLL99 One way of doing this without iterative macro

AncientPandaman · Accepted Answer

or you get the last column first. and join afterward.

sparksun · Accepted Answer

I think you don't have to use iterative macro even if there are a number of columns