SOLVED
Combine fields and return in a singel cell of a table with line brake after each field
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
Zukunft
5 - Atom
‎09-24-2022
04:44 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I'm challenged with a task to read a table and combine all cells returning in a table in a single cell with line break after each reading cell.
Like this example
Input | |||||
Concern # | Status | Team | Action 1 | Action 2 | other |
1 | TWO | Y | Y | WAR | A-TEAM | Name-1 | Name-2 | Nane-3 | Group - 1 | Test Version 1 | Step1=Step2 | Test1 | | | | | Any other 1 | | | | | | |
Output | |
Concern # | Concern Summary |
1 | TWO | Y | Y | WAR A-TEAM | Name-1 | Name-2 | Nane-3 | Group - 1 Test Version 1 | Step1=Step2 | Test1 | | | Any other 1 | | | | | | |
Thanks for help.
Solved! Go to Solution.
Labels:
- Labels:
- Workflow
3 REPLIES 3
21 - Polaris
‎09-24-2022
05:33 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Zukunft
We can use the Transpose tool to bring the data field into a vertical format then a Summarize tool will do the rest.
‎09-24-2022
05:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Qiu
works as needed Thank you. :-)
21 - Polaris
‎09-29-2022
03:38 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Zukunft
Thank you for the feedback and glad to be helpful.
