Finding a pattern in a column based on other two column pattern and then storing the start and end values in a new column
Hi,
I am trying to create a new column (in my file "Required values") which can have only binary values - 0/1 or Start/End. Its values depends upon a another column (in my file "Number of Occurrence") which has repeated pattern based on other two columns (in my file - "ID" and "Sub_set"). Too much wording, please see the attached image and data file. I tried few formulas in new columns and few fo...