Hello,
I'm trying to make a unit pivot table from different files.
I succeeded to transfer the three sheets into one.
In the attachment you can see the three tables. In each one of them there is a row "project name", but I have values that are unique to each file.
Now I want that the rows of the pivot will be all the project name from all of the sheets. how can it be done?
Thank you.
Untitled.jpg
Bookmarks