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.
Résolu ! Accéder à la solution.
@Zukunft
We can use the Transpose tool to bring the data field into a vertical format then a Summarize tool will do the rest.
Hi Qiu
works as needed Thank you. :-)
@Zukunft
Thank you for the feedback and glad to be helpful.