I am working on breaking a path sequence into smaller sub-paths, dividing the sequence whenever a specific step (e.g., "CC step") occurs.

While I’ve already evaluated a solution proposed by Mikhail Berlyant—which is always helpful—it doesn’t fully meet my requirements for this specific task. Below, I provide an example table to illustrate the input and the desired output.

|   bk_account_id   |   OrderDate_short |   transaction_id  |   circuito_vendita    |   order_number
|   0013X000036ayHHQAY  |   2024-01-06  |   1401355967549   |   HD  |   1
|   0013X000036ayHHQAY  |   2024-01-29  |   1406866158526   |   HD  |   2
|   0013X000036ayHHQAY  |   2024-02-18  |   1411736335057   |   HD  |   3
|   0013X000036ayHHQAY  |   2024-03-11  |   1416996524888   |   HD  |   4
|   0013X000036ayHHQAY  |   2024-04-06  |   1423206748394   |   HD  |   5
|   0013X000036ayHHQAY  |   2024-04-27  |   1428196926388   |   HD  |   6
|   0013X000036ayHHQAY  |   2024-05-22  |   1434177135732   |   HD  |   7
|   0013X000036ayHHQAY  |   2024-05-22  |   1434277140369   |   HD  |   8
|   0013X000036ayHHQAY  |   2024-07-28  |   1450247652330   |   HD  |   9
|   0013X000036ayHHQAY  |   2024-08-13  |   1454187752650   |   CC  |   10
|   0013X000036ayHHQAY  |   2024-08-23  |   1456557807412   |   CC  |   11
|   0013X000036ayHHQAY  |   2024-09-03  |   1459247881009   |   HD  |   12
|   0013X000036ayHHQAY  |   2024-09-09  |   1460567912458   |   CC  |   13
|   0013X000036ayHHQAY  |   2024-10-02  |   1466178067672   |   HD  |   14
|   0013X000036ayHHQAY  |   2024-11-25  |   1479108483077   |   CC  |   15
|   0013X000036ayHHQAY  |   2024-12-23  |   1485758732809   |   CC  |   16
|   0013X000036ayHHQAY  |   2025-01-25  |   1505909001881   |   CC  |   17
|   0013X000036ayHHQAY  |   2025-02-13  |   1510399136691   |   CC  |   18

Desired Output:

HD-\>HD-\>HD-\>HD-\>HD-\>HD-\>HD-\>HD-\>HD  CC-\>CC  HD      CC     HD   CC-\>CC-\>CC-\>CC