Q: how to create summary daily lists from another, and reverse
Or you can use Advanced Filter for the second table.
Check: Copy to another location
Database= header + thing
Criteria= blank header + =OFFSET(thing,,n)="x" for n={1,2}
Then replace result headers with dates.
|