Forum Discussion
KalyanPrasad
Aug 08, 2024Copper Contributor
nested xlookup
Hello My input data is my desired output is how to achieve this result, basically, i need to get the values for whatever date i enter in the column header. it needs to pull t...
- Aug 08, 2024
See the attached version.
datawizard
Jun 09, 2025Copper Contributor
I would just insert a pivot based on that table change rows and column (transpose) to get the sums