Forum Discussion
Pivot table
Hello everyone! There is a problem with pivot table function, doesnt show me correctly data from another sheet. I have divided sheets by responsible people including tasks names, responsible na...
Thank you.
First, I'd recommend to keep data in structured tables. It's easy to add and transform data, easier to support.
In general that's task for Power Query - query each table, by another query combine them together, remove not needed columns and load back into the grid. Result is like
SergeiBaklan Thanks!
Did some thinks how to combine 3+ sheets in one.
Completed task