How do I create a new column that will populate values from column 2 or 3 based on values from column1?I am trying to create a new column "Desired Column" that will combine columns "Sample1" and "Sample 2" depending on value from column "Group". Can anyone point me in the right direction for this?
Data TableWindowsRe: How do I create a new column that will populate values from column 2 or 3 based on values from column1?Perhaps the "Match" function will do the trick? In the formula editor Conditional > Match
Re: How do I create a new column that will populate values from column 2 or 3 based on values from column1? Thanks KarenC, that's exactly what I've been looking to find. It works prefect!
