Hi, Need help to get the below output. Thank you in advance. Sample Input: Col A/Col BCol CCol DCol ECol F1123456ABC ABC123 AxNote 1DEF187 AxNote 2GHF197 AxNote 2HML321 AxNote 2LKH456 AxNote 1LMB879 AxNote 1 *Note 1**Note 2 Sample Output: Based on the Note in Col F, need to add * if it has Note 1 or ** if it has Note 2 to data in Col E Col A/Col BCol CCol DCol ECol F1123456ABC ABC123 Ax*Note 1DEF187 Bx**Note 2GHF197 Cx**Note 2HML321 Dx**Note 2LKH456 Ex*Note 1LMB879 Fx*Note 1 *Note 1**Note 2

Add data to a column based on another column values

Hi,

Need help to get the below output. Thank you in advance.

Sample Input:

Sample Output: Based on the Note in Col F, need to add * if it has Note 1 or ** if it has Note 2 to data in Col E

Add the following formula expression to [Col E]:

IF [Col F]="Note 1" THEN [Col E]+"*" ELSEIF [Col F]="Note 2" THEN [Col E]+"**" ELSE [Col E] ENDIF

Maybe we can try like this?

My take on this

Workflow:

1. Using filter to split data and notes

2. Using regex tool to extract mark and notes

3. Using find and replace to do vlookup and map marks

4. Using formula tool to add the associated mark

5. Using selected tool to keep the required columns

Hope this helps : )

Add the following formula expression to [Col E]:

IF [Col F]="Note 1" THEN [Col E]+"*" ELSEIF [Col F]="Note 2" THEN [Col E]+"**" ELSE [Col E] ENDIF

Thank you all for the response.. HomesickSurfer's solution worked easily for me..