Happy Friday Folks.
Any ideas? I have data (as an example) that looks like this:
[TABLE="width: 826"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD] Cust. # [/TD]
[TD][/TD]
[TD]SVC[/TD]
[/TR]
[TR]
[TD="align: right"]2400001[/TD]
[TD] [/TD]
[TD]KSBAS[/TD]
[/TR]
[TR]
[TD="align: right"]2400001[/TD]
[TD] [/TD]
[TD]K2B10[/TD]
[/TR]
[TR]
[TD="align: right"]2400001[/TD]
[TD] [/TD]
[TD]K2RES[/TD]
[/TR]
[TR]
[TD="align: right"]2400001[/TD]
[TD] [/TD]
[TD]K2TPD[/TD]
[/TR]
</tbody>[/TABLE]
On another sheet I am trying to figure out how to make it look like this in a single row:
Cust.[TABLE="width: 455"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD] #[/TD]
[TD] SVC 1[/TD]
[TD]SVC 2[/TD]
[TD]SVC 3[/TD]
[TD]SVC 4[/TD]
[/TR]
[TR]
[TD]2400001 [/TD]
[TD] KSBAS[/TD]
[TD]K2B10[/TD]
[TD]K2RES[/TD]
[TD]K2TPD[/TD]
[/TR]
</tbody>[/TABLE]
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:
[TABLE="width: 826"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD] Cust. # [/TD]
[TD][/TD]
[TD]SVC[/TD]
[/TR]
[TR]
[TD="align: right"]2400001[/TD]
[TD] [/TD]
[TD]KSBAS[/TD]
[/TR]
[TR]
[TD="align: right"]2400001[/TD]
[TD] [/TD]
[TD]K2B10[/TD]
[/TR]
[TR]
[TD="align: right"]2400001[/TD]
[TD] [/TD]
[TD]K2RES[/TD]
[/TR]
[TR]
[TD="align: right"]2400001[/TD]
[TD] [/TD]
[TD]K2TPD[/TD]
[/TR]
</tbody>[/TABLE]
On another sheet I am trying to figure out how to make it look like this in a single row:
Cust.[TABLE="width: 455"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD] #[/TD]
[TD] SVC 1[/TD]
[TD]SVC 2[/TD]
[TD]SVC 3[/TD]
[TD]SVC 4[/TD]
[/TR]
[TR]
[TD]2400001 [/TD]
[TD] KSBAS[/TD]
[TD]K2B10[/TD]
[TD]K2RES[/TD]
[TD]K2TPD[/TD]
[/TR]
</tbody>[/TABLE]
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.