after macro roster.xlsxbefore macro roster.xlsx

Can anyone help with how to create a simple macro to how to make the "before macro" file into the "after macro"?

I have info on many different companies, and employees at each company. I want to transpose (is that the right word???) such that there is one column with all employee names, one with all salaries, one with all education levels.

I'm actually working with a much larger document (100 companies, 50 employees per company, 18 columns of individual employee info per employee), but I think if I get the basic idea of macro format I can adjust the specifics.

Thanks for any tips and guidance!