I have 2 excels i am copying data from one and paste in other but ineed to update the first column as A how to do that

Help Studio
, , ,
1

i have 2 excels i am copying data from one and paste in other but i need to update the first column as A how to do that

i need to check if data is available in that particular row then update A in first column

data that i copied will be pasted from column B onwards column A is blank to update as A