Hi everyone,
I have a problem that I can not solve on my own. I have a list of employees with salary data for different time periods (from date - to date). Same employee can therefore appear on multiple rows on that list.
I need to transform that into a list into a list with employee number as a row headers and months of 2011 as column headers and populate that list with date for actual salary for that month from above list.
I enclose an example of how the list look like.
Grateful for any tips and tricks that you might throw my way.
Best regards to you all.
Draggan
Bookmarks