Originally Posted by
Roel Jongman
Pivottables will be a good solution for your problem, they can be very flexible but you need some improvements of your input date.
- remove the subtotals (lines with "Ergebenis") from your data
- Make sure every row has a date (and time) ad name Best solution is to have it arranged in the source so the output gives that info on all lines
If you cannot get your source file to deliver it like that then there is a trick to do it.
HOw to fill empty field with the value
1. Select Column A and B
2. Press F5 (Go to screen pops up)
3. Press Special button
4. Select "Blanks" (will select only empty cells)
5. Press OK
6. IN the active cell type "=" and point to cell right above
7. Press CTRL + Enter at the same time
Now all Blank cells will get a formula pointing to the cell just above it. and your data is complete.
When that is done it is easy to make a pivottable, as I have done in the attachment.
For The date and time you can eighter use grouping or make help columns in your data (Tabelle1)
I choose grouping this time..
With slicers you can easy filter on the for you important fields
Bookmarks