I need a program, preferrably an excel macro, that will convert the input to output as shown in my sample here.
[login to view URL]
PLEASE CHECK THE ABOVE SPREADSHEET, and only bid, if you understand the logic.
output is all possible combination of unique option name..for each title..
Option 1 has 2 values... Option 2 has 2 values.. hence there are 4 rows for Title 1
The above is only a sample.. It should work for any data..