Can anyone assist please. Two orders displayed here, two IDs. I'd like to have a formula for Col E showing an appended Order ID per customer Code as example. So far, I have only worked out how to have an incremental number appended.
Order ID | Line Item | Customer Code | Append Order ID | |
2786 | 1.120 | Yar | 2786.1 | |
2786 | 1.120 | Yar | 2786.1 | |
2786 | 1.120 | Yar | 2786.1 | |
2786 | 1.140 | Noy | 2786.2 | |
2786 | 1.140 | Noy | 2786.2 | |
2786 | 1.140 | Noy | 2786.2 | |
2786 | 1.210 | Abo | 2786.3 | |
2786 | 1.210 | Abo | 2786.3 | |
2786 | 1.210 | Abo | 2786.3 | |
2787 | 1.120 | Eka | 2787.1 | |
2787 | 1.120 | Eka | 2787.1 | |
2787 | 1.120 | Eka | 2787.1 | |