Hello,
I need to fill one group of tables with the values of another group of tables.
In example you may see the tables on the top and on the bottom.
So for every city in each table on the top, I need to take a value of particular time and day of the week and fill the corresponding cell in the tables of the bottom.
I filled a part of the first bottom Paris table as an example as it should be.
Any clues how to make it? I would be really thankful for any kind of advise.
Example.xlsx
I think your data is not well formatted to analyse the data.
See the re-arange of the data, and after that a pivot table.
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Oh, you did an impessive job! But unfortunately I need to see days of the week in pivot table, date isn't so important.
The point is to see an exact value for every day of day week for particular time periods for every city.
So can you advise how can i format it properly to see such information?
Then you can add the day in your file, and in the pivot table.
See the attached file.
you can change it in Query editor with:
Formula:
Please Login or Register to view this content.
but you need do it on your own file. If not, you will get NL version DayOfWeekNameeg. zondag, donderdag... etc
eg. see att.
Last edited by sandy666; 08-20-2017 at 04:08 PM.
Thank you all. I will try it tomorrow.
or you can try this one
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks