I am trying to get a solution such that from the input sheet("Current") i am trying to make one row per company that would make all the subsequent Columns i.e. Proposal#(Column E), Proposal Text(Column F), BNYM Rec (Column G) to be moved on to columns J:X. Column E is unique but now Column A will have unique Company Name but with empty cells for the following Proposal#. Both are distinct. I need the final as a worksheet as I will be working on it to populate to word template using bookmarks. I guess you get my point? Thanks for help.
Hey Guys I have attached another sample sheet. Thanks in advance.
Bookmarks