Remove null values

[hcho2]

How can I transform data from this:

A1	B1
A11
A12
A13
A14
	B11
	B12
	B13
	B14

To this?

A1	B1
A11	B11
A12	B12
A13	B13
A14	B14

[OTrieger]

@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.

[hcho2]

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.

[EKasminsky · Accepted solution]

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