Create table with multiple attributes from columns and rows

[phamilton006]

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!

[Thableaus · Accepted solution]

Hi @phamilton006 

See workflow attached and let me know if this works for you.

Cheers,

[phamilton006]

That worked! Thanks!