Excel - Pivot multiple columns of data and compare data

Question

Hello -

I am trying to create a workflow to accomplish the following - compare Test 1 q1 data with Test 2 q4 data, presented as follows:

1. Column A = Location

2. Column B = Location Code

3. Column C = Code currently housed in row 13 (example - C001000, C004000, etc.)

4. Column D = State filing method from "Test 1 q1" file

5. Column E = State Provision Current Calculation from "Test 1 q1" file

6. Column F = State Provision Deferred Calculation from "Test 1 q1" file

7. Column G = State filing method from "Test 2 q4" file

8. Column H = State Provision Current Calculation from "Test 2 q4" file

9. Column I = State Provision Deferred Calculation from "Test 2 q4" file

Test 1 q1.xlsx

test 2 q4.xlsx

AncientPandaman · Accepted Answer

@FrederikE I suggest you can try to learn more on dynamic rename and field info.

these 2 tools are helpful when manipulate the Field name.

Tool Mastery | Dynamic Rename - Alteryx Community attribution dynamique d'un nouveau nom dynamisch umbenennen