Dear all,
Please review attached file.
The data below "Scenario" is my present data and "Output Required" is something what i am looking for...
Process (Refer "Scenario" data):
1) If any of the Row "Type" is "O", then data available in 'commodity' column must be move to next upper "R" type column under "Col2" cell
2) After moved, "O" type row has to be deleted.
Is it possible to do..?
Please help.
Bookmarks