SKU# | 2301 | 2301 | 2301 | 50010 | 5000 | 50010 |
$ | Units | Stores | $ | Units | Stores | |
1 | 23 | 3 | 50 | 15 | 2 | 48 |
2 | 6.99 | 1 | 50 | 17 | 2 | 48 |
3 | 30 | 6 | 50 | 6 | 1 | 48 |
4 | 0 | 0 | 50 | 15 | 2 | 48 |
5 | 100 | 20 | 50 | 15 | 2 | 48 |
6 | 72.32 | 15 | 50 | 7 | 1 | 48 |
7 | 6.99 | 1 | 50 | 18 | 2 | 48 |
8 | 28.57 | 4 | 50 | 6 | 1 | 48 |
<tbody>
</tbody>
Hi all -
I'm usually fairly savvy with index matching, but struggling with this due to the criterion I have running different directions in a pivot style data source (SKU # and Metric Type are in the top 2 rows, Sales WK is the first column, data flowing in correspondence across the the rows and columns).
The data is a bit repetitive and my summary page displays each metric chronologically (Weeks are running 1 -52 across the top, and the SKU numbers are running down the first column). On summary sheet recaps $, one sheet recaps Units sold and the last recaps store count.
Anyone have a recommendation on the best way to grab the data and get it re-toggled? Its a large amount.... over 350 SKUs in the source file.
Much appreciated!