Hello!
I'm trying to find out a way to create a formula to find and gather specific data per row value.
The sheet has multiple store location as a row header with information underneath it. I need it to find and gather data for each and every store specifically.
For example.
The sheet below is where it gathers data from the sheet above (formula sheet)
Would this be possible considering each row may be different per store name due to some store not having specific sizes?
Thank you!
I'm trying to find out a way to create a formula to find and gather specific data per row value.
The sheet has multiple store location as a row header with information underneath it. I need it to find and gather data for each and every store specifically.
For example.
| Store 1 | ||
| Apple | Small | 1 |
| Apple | Medium | 2 |
| Apple | Large | 3 |
| Apple | X-Large | 4 |
| Apple | XX-Large | 5 |
| Store 2 | ||
| Apple | Small | 3 |
| Apple | Medium | 2 |
| Apple | Large | 1 |
| Store 3 | ||
| Apple | X-Small | 7 |
| Apple | Small | 8 |
| Apple | Medium | 9 |
| Apple | Large | 6 |
The sheet below is where it gathers data from the sheet above (formula sheet)
| Store 1 | Store 2 | Store 3 | |
| X-Small | 7 | ||
| Small | 1 | 3 | 8 |
| Medium | 2 | 2 | 9 |
| Large | 3 | 1 | 6 |
| X-Large | 4 | ||
| XX-Large | 5 |
Would this be possible considering each row may be different per store name due to some store not having specific sizes?
Thank you!
