Hello This is my question, Below is an example of what I mean, Thanks!
In SQL:
Table 1:
| Part Number | Sequence | Notes |
|---|---|---|
| AS3021 | 1 | Used for Water Cooling |
| AS3021 | 2 | Only used with N/N part |
| AS3021 | 3 | Used for In House |
| AS3021 | 4 | Sold by Amazon.com |
Resultant Table:
| Part Number | Sequence | Notes |
|---|---|---|
| AS3021 | 1 | Used for Water Cooling Only used with N/N part Used for In House Sold by Amazon.com |
So basically, combining a text with another row's text based on sequence, and the part number.
