Below is the detailed description.
The base file contains 4 columns and Column C has multiple values - refer sheet "tinku" for the raw data.
The requirement is have single value for column C data and create new row for every value in Column C to having column A and Column b fixed.
I have attached expected result file for your reference, Please refer "Result Expected" sheet.
I tried multiple option but could not succeed.
Bookmarks