What options are available in the Column Swapper?

• A. Find
• B. Find and Replace
• C. Find and Remove
• D. Find and Swap

Answer: (B)

Column Swapper often needs to control what happens to the values as you reassign which column holds which data. The Find and Replace option is the best fit here because it lets you locate specific values in the column and substitute them during the swap, which is essential when aligning data from different sources or codes. Simply finding values doesn’t change them, so it wouldn’t accomplish the swap’s needed behavior. Removing values would discard data, which isn’t what a swap should do. The Find and Swap idea implies swapping without modification, but in this tool the practical workflow includes modifying values as part of the swap, making Find and Replace the correct capability.