Afternoon all;
The code i am trying to get to work
Two columns of data which has been exported from a web based ecommerce which attaches to our Website.
The first Column has the Member number (E) and the second has notes from the customer card (F). Each entry into the card creates a new row in the spreadsheet.
I am trying to get the cells that have the same customer number to have the cell (F) to be consolidated into cell (G).
I have successfully been able to do this in the past with a sum
for the same layout but I am struggling to have text to do the same thing.
[TABLE="width: 500"]
E
[/td][td]F
[/td][td]G
[/td][/tr][tr][td]Customer Number
[/td][td]Notes
[/td][td][/td][/tr][tr][td]2
[/td][td]Cancelled WC
[/td][td][/td][/tr][tr][td]2
[/td][td]Voicemail left to update
[/td][td][/td][/tr][tr][td]2
[/td][td]Bryan rang about White Label
[/td][td][/td][/tr][tr][td]3
[/td][td]Updated
[/td][td][/td][/tr][tr][td]20
[/td][td]Changed from IRS to OSWC
[/td][td][/td][/tr][tr][td]20
[/td][td]Updated CC
[/td][td][/td][/tr][tr][td]20
[/td][td]Rang to update details
[/td][td][/td][/tr][tr][td]20
[/td][td]Upgrade from Gold to Platinum
[/td][td][/td][/tr]
[/TABLE]
[TABLE="width: 358"]
[/TABLE]
Jezza