I'm familiar with PivotTables, but it will not work because I need the actual values split out, not summed (or any of the other pivot functions). I will need to run some more advanced stats on the sampling that requires each sample for each index, and that's where the PivotTable falls a bit...
I have data output where there is an index column and a sample of values for each index. Basically I want to convert:
Index | Value
-------------
1 | 2
1 | 5
1 | 3
1 | 1
2 | 1
2 | 1
3 | 5
To a table:
Index 1 | 2 | 3 |
------------------------...
We have a discrepancy in our item stock. We are showing item quantities allocated, but when we look in the item allocation inquiry, there is nothing there for that item, even with all sites and all date range selected. Any ideas?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.