I know how to concatenate based on same column name but Im trying do something a little different,
Here is how my table looks like right now
| Order details | 1.1 ~~~Info~~ |
| Order details | 1.2 ~~~Info~~ |
| Order details | 2.1 ~~~Info~~ |
| Order details | 1.1 ~~~Info~~ |
| Order details | 1.2 ~~~Info~~ |
| Order details | 1.3 ~~~Info~~ |
| Order details | 1.4 ~~~Info~~ |
| Order details | 2.1 ~~~Info~~ |
| Order details | 3.1 ~~~Info~~ |
| Order details | 1.1 ~~~Info~~ |
This is my desired output. Basically I would like all related details in the same cell as opposed to all in different ones. So order details (1.1 - 1.1] ,with the second 1.1 being exclusive, be in the same cell. Thank you any help would be much appreciated.
| Order details | 1.1 ~~~Info~~ 1.2 ~~~Info~~ 2.1 ~~~Info~~ |
| Order details | 1.1 ~~~Info~~ 1.2 ~~~Info~~ 1.3 ~~~Info~~ 1.4 ~~~Info~~ 2.1 ~~~Info~~ 3.1 ~~~Info~~ |
| Order details | 1.1 ~~~Info~~ |