Happy Friday Folks.
Any ideas? I have data (as an example) that looks like this:
<colgroup><col><col><col></colgroup><tbody>
</tbody>
On another sheet I am trying to figure out how to make it look like this in a single row:
Cust.
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
Such that the formulas in SVC 1 SVC 2 SVC 3 SVC 4 etc. know to pull in the value "KSBAS" into the SVC 1 column since it is the first value to appear in the SVC column on the source sheet for that customer # 2400001, and have the subsequent SVC 2 SVC 3 and SVC 4 etc columns know to continue to pull in the next SVC value that appears for that customer # on the source sheet until the customer ID changes.
Any help is appreciated! I am guessing INDEX may have something to do with it but I am sorely inexperienced with INDEX related formulas.
Any ideas? I have data (as an example) that looks like this:
Cust. # | SVC | |
2400001 | KSBAS | |
2400001 | K2B10 | |
2400001 | K2RES | |
2400001 | K2TPD |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
On another sheet I am trying to figure out how to make it look like this in a single row:
Cust.
# | SVC 1 | SVC 2 | SVC 3 | SVC 4 |
2400001 | KSBAS | K2B10 | K2RES | K2TPD |
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
Such that the formulas in SVC 1 SVC 2 SVC 3 SVC 4 etc. know to pull in the value "KSBAS" into the SVC 1 column since it is the first value to appear in the SVC column on the source sheet for that customer # 2400001, and have the subsequent SVC 2 SVC 3 and SVC 4 etc columns know to continue to pull in the next SVC value that appears for that customer # on the source sheet until the customer ID changes.
Any help is appreciated! I am guessing INDEX may have something to do with it but I am sorely inexperienced with INDEX related formulas.