SOLVED
Merging top 2 rows to make a header
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
AliceG
5 - Atom
‎03-30-2022
07:27 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Labels:
- Labels:
- Workflow
3 REPLIES 3
21 - Polaris
‎03-30-2022
07:46 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@AliceG
Maybe we can do something like this?
‎03-31-2022
04:13 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Brilliant, it works perfectly thank you.
‎03-31-2022
05:30 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
