I need to sort my data in excel according to column for example if i have the data in A column it should be in A column and level 1 if B column put the data in A column and level 2, if C column put data in A column and level 3 and so on so forth, (Level column will be created in B column after the filtration)
Could u help me with that
Sorry I didn’t get you. Could you please show me sample input and output for better understanding.
Here you are the first sheet for input and the second sheet the output
Anybody can help me with that ??