All,
Here is the requirement
Move the "Source" worksheet to "Target" Worksheet as below and add new columns in Target Sheet by Merging Columns from Source File
Here is the requirement
Move the "Source" worksheet to "Target" Worksheet as below and add new columns in Target Sheet by Merging Columns from Source File
Source Column | Target Column | New Columns in Target sheet |
C | A | |
D | B | |
E | C | |
CONCATENATE("Job Code - ",Source!B2,CHAR(10),"Percentage - ",Source!G2) | Target D Column | |
IF(Source!C2<>"","Checked","") | Target E Column | |
IF(Source!C2<>"","High","") | Target F Column |