I am having a sheet where data is in the form shown below
Here, Column A B C D and H I J K have same name excet difference of _1 and _2.
I want the result like
where WR SD OP and XX are the last words in the column name and if column contains any value other than 0 then it should be inserted in Remark column accordingly in the format shown and string matching is done after that.
Can anyone help in achieving the remark situation in this…