Dear All,
I am facing some challenge to concatenate rows based on the column id can some one help on how can we achieve this?
below is the scenario.
Example: I have a part 1 which goes from line 2022 - 2060 and from 2060 - 1692 (But i have this information in two different columns). I need an output to show line information in one row like 2022-2060-1692 for part 1. can anyone help us on this?
Input:
Part | Line from | Line To |
1 | 2022 | 2060 |
1 | 2060 | 1692 |
2 | 1849 | 2022 |
2 | 1842 | 1849 |
3 | 1692 | 1699 |
3 | 1699 | 2022 |
3 | 2022 | 2025 |
Expected Output:
Part | Line Info |
1 | 2022-2060-1692 |
2 | 1842-1849-2022 |
3 | 1692-1699-2022-2025 |
Best Regards,
Shashank
@Shank
Better you can post this on Design forum. :)
I believe for sure Multi-row tool can do this, but I tried with a Unique tool.
Thanks for the work Around, Sure going forward will post these kind of messages in different forum.
With the workaround which you have provided will not get the intended result.
for example if part 2 should flow from 1842 to 1849 then 2022, but with the workaround which you have provided will not provide that link. this something like transport link first you have to go from location A to B then C.
is there any other workaround to achieve this?
@Shank
Thanks for the feedback and now I realized it is not that simple...
Can you check the accepted solutions if help.