Transpose and Union

Asimkz

Hello All, I have a data set that contains different values for different "levels".  For example I have "Lvl1 Key", "Lvl2 Key", Lvl3 Key" and "Lvl4 Key" and others such as "Lvl1 Component", Lvl2 Component" just to give an example.  I would like to create one column for "Level" and create corresponding columns for the others such as Key, Component, Inclusion, # Of Components.  I have used a transpose tool and separated out Lvl1 Key and Lvl1 #of Components but when I union it back it create two separate rows for each input.  Anyone know how to accomplish this without running into multiple rows?  Attached are screenshots of the workflow.  

Capture.PNG

Capture2.PNG

TonyA

I'm not 100% clear what you're asking for. Next time please include some sample data and expected output. Anyway, I think you're looking for something like this:

See the attached workflow. The important thing is to isolate a field that you can group levels on, otherwise the Crosstab tool will just restore the columns to the way they were before the Transpose.

Does this help?

Transpose and Crosstab.yxmd