Changing layout

[pablofonto]

Hello Everyone,

I'm pulling my hair off with this situation. I have an excel file that was given to us by the payroll department of our company, but my manager doesn't like the layout in which was given to us. I've attached a sample of the file, the file has two sheets the first one is how the original file looks like and the second sheet "final look" is how my manager want the file to look.The original file is pretty big, it's for 33 different employees and it contains 93,500 rows. I think it will take forever to do this manually, any ideas would be really appreciated.

Thanks,

Pablo

 

[Matthys]

Use Pivot Tables

Hi

I think the best way to do this conversion will be to use Pivot Tables, I'm not an expert on Pivot Tables but the concept is pretty straight forward.

 

[Matthys]

Pivot Table Example

I did this one in about 2 minutes, with some tweaking you should be able to get the desired outcome.

 

[pablofonto]

Thank you Matthys! I don't believe my manager wants a Pivot table layout, but I will check with her and see if she bites on it.

thanks again,

Pablo