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

Question

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 Answer

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.