Book1AB3Invoice NumberDocument Number4M1000151000000005M1000162251000002227228910OUTPUT A)11Invoice NumberDocument Number12M10001Yes1322Yes1415OUTPUT B)16Invoice NumberDocument Number17M10001510000000018225100000222Sheet1
A3:B13 is Table1
Column A is made up of either text or numbers.
Column B...