Stack Table without removing field names

[samxhander09]

Hi community! I'm trying to stack 3 data streams to look like a table for analysis. The below happens when I use union tool. it removes the field names.

But this is how I need it to look like.

\

How can I possibly do this? Thank you.

[cjaneczko · Accepted solution]

One way would be to use the Field Info tool, then crosstab the Name and Union that above the second set of data. 

[MilindG · Accepted solution]

@samxhander09 

[Jonathan-Sherman · Accepted solution]

Hi @samxhander09,

I would probably go with the approach of the field info tool to create a dummy row and combine as part of the data set before unioning all of the tables together. I've attached an example.

Kind regards,

Jonathan

[samxhander09]

Thank you so much to all of you three for the input! Helped me a lot!