Best way to do this? Transpose, join, crosstab trying to "cross tab" pairs of columns

[Nathan_S]

Background

Doing an email to Network ID crosswalk with the end result of a table with one row per provider with their email and network ID, their manager's email and network ID, their director's, etc. 

At the abstract level I'm needing to match data in one column with the multiple columns that are in another table. In my mind that easily lends itself to a transpose to collapse the multiple columns into one (well two), then join to join on one column, but then I get stuck on how to cross tab out the results so that there are pairs of columns of the joined data in the end result. 

[CoG · Accepted solution]

Multi-Column Cross Tab can be performed with a Transpose before the Cross Tab Tool. Your workflow is just as valid though!

Hope this helps and Happy Solving!

[Qiu · Accepted solution]

@Nathan_S 
Not sure it is the best way, just another way.😁

I will do some manipulation to the data out of J anchor of first Join tool.