Crosstab - Splitting row label to stay with corresponding value

Question

Alteryx newbie here.  I am wondering how complicated the data reformatting below would be.  The new data set will have 1 row for the Invoice/Line Item combo.

Specifically, how do I split the TJ Name column to align with the appropriate tax type?

Attached is sample date in the current format.  Please let me know if my question is not clear or I can provide any additional info.

Thank you!

John

CURRENT FORMAT    InvoiceLine ItemTax TypeTJ NameTaxable AmountTax00120State TaxArizona                                    500.00                       24.0000120County TaxMaricopa                                    500.00                         3.0000130State TaxArizona                                    125.00                         6.0000130County TaxMaricopa                                    125.00                         0.7500220State TaxWashington                                       50.00                         4.00

PREFERRED FORMAT      InvoiceLine ItemTJ Name (County) County Taxable Amount  County Tax TJ Name (State) State Taxable Amount  State Tax 00120 Maricopa                                       500.00                                         3.00Arizona                                  500.00                        24.0000130 Maricopa                                       125.00                                         0.75Arizona                                  125.00                           6.0000220   Washington                                     50.00                           4.00

Crosstab Alteryx sample.xlsx

JessieC · Accepted Answer

@john86901

Here is what I came up with -

1. Filter null rows

2. Remove null columns

3. Filter on Tax Type to split the data into County vs. State

4. Join on Invoice and Line Item

5. Select to rename fields to align

6. Union Washington state record back with other records