Took the solution to work only to find out, that TREATAS isn't working there - Excel 2016 32 bit is the "tool", I have to work with there. Hope som...
Hi Riny Thanks a lot. My plan was to be able to make a profile for each department and each individual employee. Guess I can use your tip on ...
Trying to upload again
With a simple example file, where employee# is the common denominator, I hope to be able to illustrate the challenges I'm facing with data from work. ...
Hi Riny I got that far myself, but the problems started with the different data regarding - hours worked, completed days of holiday, days sick and ...
Hi Catalin That is what I have been trying to suggest - maybe in other words - but this was my idea. Guess you agree with me, that it can be don...
Hi Catalin I am not going to combine the data source files in Power Query - only in the data model. With unique column headers ( copying the case#...
Hi Catalin Thanks - but this is not the issue with my data sources. They consist of up to 12 different data files with different contents, and o...
Hi Catalin I want to combine all data source files with my main file and take parts of data from these in Power Pivot and charts. Erik
Hi Mynda and Phil I have made a file with simple mockup data and in two sheets tried to show to show you my challenge and my idea of a solution. ...
Hi Mynda and Phil The data is from work and rather sensible, but as an example this could be part of a file: District - number and text - I on...