Formulas to help reformat large spreadsheet

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.

Will you please attach a sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired results are also shown (mock up the results manually).

3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

4. Try to avoid using merged cells as they cause lots of problems.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.

Hi, welcome to the forum

To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Probably you can use PowerQuery aka Get&Transform

• What is PowerQuery? see here: Getting Started with PowerQuery (Get&Transform) in Excel

I added them to my original post - sorry for not including them the first time! It's also worth mentioning that I'm using a workplace computer and no programs or extensions can be downloaded.

Edit: If it makes the job substantially easier, the department, position title, and working title can be left out and I can just run a vlookup later to get those. Basically I need all of my job codes to go from about 4000 columns into one, and the position numbers to go into another.