Copy data while skipping columns and transpose layout

[kerrimaharaj]

Hi. I have included a screenshot of some data and the layout I am trying to achieve with formulas. I did the layout manually but the actual data file is huge and I am sure there is an easier way to do this.

I am trying to create a formula to copy certain information and adjust the way it is laid out.

For example, the Office headings are going across the columns, but I need it laid out in one column instead, but when I copy down, I need to skip 5 columns, and so on for the rest of the information.

Next, for each Office I need to get the FTE at 2021 and 2022 and Salary info laid out across one row and not in different rows as the data file. Then repeat for Office 2 and 3.

Any suggestions would be appreciated.

Thanks
Kerri