Formulas to help reformat large spreadsheet

[cj51794]

I'm having some issues figuring out how to format a large spreadsheet (~400 rows, ~8000 columns) and was hoping somebody here might have some ideas or advice. I'm fairly new to Excel and can do the basics, and I think I'm tech savvy enough to figure out most of the features - anything involving VBE is over my head, though.

Currently, my spreadsheet looks like this. Capture.PNG

All of the numbers in B, D, F, etc. are job codes. Numbers in C, E, G, etc. are position numbers.

I need it to look like this.
Capture2.PNG

Job codes in one column, position numbers in the next, department after that, etc.

Obviously this could be done by hand, but the size of the spreadsheet makes that difficult and time consuming - plus we are trying to avoid human error, which is bound to happen with a 400x8000 cell worksheet. Does anybody have a suggestion of where to start or what formulas/features might help me do this?

Edit: I attached samples of the current workbook and the desired outcome.