Hi all,
This is the input I have:
| [Null] | Blue Book | Blue Book | Red Book | Red Book |
| [Null] | Account A | Account B | Account A | Account B |
| Store 1 | $20 | 0 | $30 | 0 |
| Store 2 | $10 | 0 | $40 | 0 |
| Store 3 | 0 | 0 | 0 | 0 |
| Store 4 | 0 | 0 | 0 | 0 |
And I'm hoping to achieve something like this using the leftmost column and the top two rows in the table. Because there is a lot of other info in this file, the headers are the generic F1, F2, etc.
| Store 1 | Account A | Blue Book | $20 |
| Store 1 | Account A | Red Book | $30 |
| Store 1 | Account B | Blue Book | 0 |
| Store 1 | Account B | Red Book | 0 |
| Store 2 | Account A | Blue Book | $10 |
| Store 2 | Account A | Red Book | $40 |
| Store 2 | Account B | Blue Book | 0 |
| Store 2 | Account B | Red Book | 0 |
I have been able to make a "mapping" using the append tool that contains the correct combinations of Stores, Accounts, and Books, but I need to find some way to fill in the numbers. Any help would be appreciated!
