iterative Macro From right column to left Column

[BRRLL99]

Hi

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

h1	h2	h3	h4
product1
product2
product3	sub1
product4	sub2
product5	sub3	sub_1_1
product6	sub4	sub_1_2	sub_2_1

h	mapped
sub_2_1	a
sub_1_2	b
sub_1_1	d
sub2	f
sub4	k
sub3	m
sub1	o

Expected Output:

h1	h2	h3	h4	m
product1
product2
product3	sub1			o
product4	sub2			f
product5	sub3	sub_1_1		d
product6	sub4	sub_1_2	sub_2_1	a

[FrederikE]

Hey @BRRLL99,

Your expected Output is just a join between column h1 of the main table and h in the second one - why do you need an iterative macro for this? 

[binuacs · Accepted solution]

@BRRLL99 One way of doing this without iterative macro

[BRRLL99]

I want my expected output in iterative macro 

because I have multiple columns

[Pang_Hee_Choy · Accepted solution]

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

[sparksun · Accepted solution]

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