How can I transform data from this:
To this?
Filter column A1 as !IsNull([A1]) as group 1, Filter column B1 as !IsNull([B1]) as group 2, Join on Record Position and rename right join B1 from Right_B1
@hcho2
Hard to say from only looking on your post, if you can elaborate ,more on how the macro works, what is the input data in each Macro input and what the macro does.
I realized manipulating batch macro is overly complicating the problem. I just revised the question so that it dealing simpler concept! Thanks for pointing that out.
