Copying Specifc Rows and Reorganizing Them

[Cubical]

Hello Again!

Always running into trouble here.

Uhmm....I attached sample file with a before and after sheet. The before contains the data I need, however its a mess. I want to copy only the data I need and reorganize it so it may look like my after worksheet. A few side notes, the Document ID (eg. VMS###, B00###) needs to be copied over from below each Cal ID into its their rightful column Document ID . Remembering they are suppose to be on the same row. The note section is moved into column N, also spacing out the rows so it is all clumped. The columns with Finalized / Cal Code / Entered By / Date Entered have their data inputted 2 rows the proper row, when copied it should be moved back into its proper row.

Greatly appreciate the help!

[Cubical]

xD guess its a lot of work.