I have a table with names (col A) and values (col B). I am trying to create a
table using col C and D to list te names and values from table1 that only
have a value.
ie
Name Value Name Value
Jim 9 Jim 9
Joe Joe 1
sue 1 Ant 5
Ant 5 Bill 3
Hill
Bill 3

This table will change on a daily bases.
Can anyone help!!!