Hi there,
I have survey data where the top row is the question number and the 2nd row is the question text. I'd like to merge them into one header showing question number&". "&question text.
How can I do this?
Solved! Go to Solution.
@AliceG
Maybe we can do something like this?
Brilliant, it works perfectly thank you.
Quick addition if someone else needs this.
I also added a record ID tool before the summarize tool and a sort tool after the summarize tool to sort by record ID, then select tool to take out the Record ID.
Because the summarize tool automatically orders by Name and I have more than 10 questions the order becomes
Field_1
Field_10
Field_11
etc.
instead of
Field_1
Field_2
Field_3
etc.