Want to concatenate the first three rows of data for column header.

[spfalconer]

       Wyle                Laura               John

       E                     D                      Q

       Coyote            Palmer             Public

----------------------------------------------------------------

I want to concatenate the first three rows so that the full names are in one cell so I can use them as column headers.  

What is the best course of action?  

[Kenda · Accepted solution]

Hey @spfalconer 

Try out the attached workflow. I use the Sample tool to get the first three rows. From there, I use the Summarize tool to concatenate the three records together with a space between each for each field. I then use the Join and Union to get the rest of the records back from the input (making sure the names are the first row) and finally use a Dynamic Rename tool to rename the headers using the first row of data.

[cmcclellan]

The columns is a bit tricky - 3 columns would be fine but more would make it trickier.

I'd use a multi-row formula like this 

You will need a separate tool for each column