Transpose, transfer, VLOOKUP....need an easy solution


I have to enter payroll information into an excel spreadsheet for another company that uses this information for auditing.  The software that we use to extract our payroll information will only extract it in a specific excel format. I am trying to think of the fastest way to extract the data from our exported information, into the spreadsheet that I need to turn over to the company, without having to type in every single line. The only thing I can think of is to transpose the data, then use my VLOOKUP function to import the data into the new spreadsheet, but it's difficult to do because of the way our software pulls the employees data.  I would like it to automatically fill in their Gross Pay, FICA, Federal Income Tax, State Income Tax, Medicare, and other deductions (areas highlighted in blue on certified payroll spreadsheet). I already have it set to where it automatically enters in their hours for me by extracting their time from the "Rename and Import" tab that I created.  So, A) How can I get, if this is even the right way to go about it, the data in transpose_payroll.xlsm to transpose correctly where I can make it a list that's easy to pull from, and B) if there's an easier way to do this, how can I get the information from transpose_payroll.xlsm to XXX.Certified_Payroll-Copy.xlsx? 



I regret to inform you that I feel offended by the overt racism on display in your forms. I wouldn't work for a company that feels the need to classify me as "Black", "White" or "Non-Hispanic White", and that's why I refuse to assist you.
Variatus (rep: 4392) Sep 29, '20 at 10:25 pm
It's not our company's spreadsheet that lists those individuals by their race.  It's The Department of Transportation's spreadsheet that OUR information has to be uploaded into.  Also it is not racist.  The government uses this information to make sure that companies are diversified.  All companies keep track of these things.  It's to make sure that white people, black people, hispanic people, etc. are all hired.  If you are working for the government they want to know the percentage of races that you have working at your company so the work is distributed fairly. You HAVE to report this so companies following these rules.  How exactly do you think the government tracks how many individuals are on unemployment? Or how many individuals are getting killed? It's not racist. It's just data. 
Shaygurl1215 Sep 30, '20 at 12:12 pm
If race makes a difference, it's racist.
Variatus (rep: 4392) Sep 30, '20 at 8:55 pm
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login