Hi All,
I am new to this forum and I have data which needs to be sorted in to multiple columns based on certain keywords (Text before and after them). Kindly help me with this and it is much appreciated, if you guys can help me out with this.
Attached is the excel with data in first sheet and desired output in second sheet.
The keywords are: INR, Manufacturer:, Composition:, Form:, Pack Size:, Mfg:
Thank and Regards,
Shivaji S
Bookmarks