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?
General example to understand the concept:- in order to reach location C from location A. I have to travel location A to B first then from B to C
A-B-C
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
