Combine column with first row of data to create new column

[Chirag_Gandhi07]

Is it possible in Alteryx Designer to be able to combine columns with the first row of data? So if my first column is LastName, and in the first rwo, the data contains Smith. How can I have it so that the column now displays LastName ; Smith instead of just LastName? I have attached a screenshot of what I am trying to do. Any help would be greatly appreciated. 

Thank you

[danrh · Accepted solution]

Chances are that your field isn't big enough. Put a Select tool just before you merge the column heading and the first row (after you Transpose) and increase the character limit. If you look back at my first response, I added the Select tool for that same reason.

[Chirag_Gandhi07]

@danrhThank you so much for your help!! 

[Chirag_Gandhi07]

@danrhWould you happen to know how to output specific fields in a dataset to excel. So I want to output fields 1-7 and 18-43 to an excel file. The rest of the fields, I don't want to be output to the excel file. I haven't come across anything like this in the community. Any help would be great

[danrh · Accepted solution]

Add a Select tool and de-select all the fields you don't want in Excel, then drop an Output Data and specify the file/location.