Apologies, but I have no idea how to paste a copy of my excel sheets into this post (other than uploading).
I see that you can add blank columns/rows but I don't see the value of this since you can' then paste into.
Could some one point me in the correct direction with attempting to achieve the following results from an Exported CSV file:
one instance of each VTR_Name
with All of the following instances of "V-Who" that the VTR_Name is coming into Speak with.
then an Additional 5 X Blank Spaces for each record (visitor) this is in-case this changes on the day, to allow for adding to additional "V_Who"/s
As shown below more than one "VTR_Name"(ie-person) may be coming in to speak with the following " V_who"/s
Note:
I don't know if this will help or not but the
the "ZZZZZZZZ" in Column B are always the "V_who"/s
"ZZZZZZZZ" in Column E are always the "V_Names"/s
Ie: Tonia smiley, Andy McGinty & Fred West are all seeing (X7) "V_Who"/s
<tbody>
</tbody>
From the following raw csv :
<tbody>
</tbody>
I see that you can add blank columns/rows but I don't see the value of this since you can' then paste into.
Could some one point me in the correct direction with attempting to achieve the following results from an Exported CSV file:
one instance of each VTR_Name
with All of the following instances of "V-Who" that the VTR_Name is coming into Speak with.
then an Additional 5 X Blank Spaces for each record (visitor) this is in-case this changes on the day, to allow for adding to additional "V_Who"/s
As shown below more than one "VTR_Name"(ie-person) may be coming in to speak with the following " V_who"/s
Note:
I don't know if this will help or not but the
the "ZZZZZZZZ" in Column B are always the "V_who"/s
"ZZZZZZZZ" in Column E are always the "V_Names"/s
Ie: Tonia smiley, Andy McGinty & Fred West are all seeing (X7) "V_Who"/s
Arv_Tme | Vtr_Name | Vtr_Type | V_Loc | V_Who | U_Section | W_Where | |
08:30-11:30 | mary Smith | Buyer | O/V | ||||
John Smith04 | 13 | N/A | |||||
08:30-11:30 | Tony Stark | STAFF | O/V | ||||
John Smith04 | 3 | N/A | |||||
John Smith05 | 14 | SMSDN | |||||
08:30-11:30 | Fiona Jones | Sales | O/V | ||||
John Smith05 | 6 | VBNM | |||||
08:30-11:30 | Tonia smiley | Sales_Ext | O/V | ||||
08:30-11:30 | Andy McGinty | Sales_Ext1 | O/V | ||||
08:30-11:30 | Fred West | Sales_Ext8 | O/V | ||||
John Smith05 | 3 | N/A | |||||
Rita Smith06 | 3 | N/A | |||||
Marie Smith07 | 13 | KKLS | |||||
Freddie Smith08 | 14 | CBDS | |||||
Tonia clark09 | 1 | RLMN | |||||
Tiger Woods 007 | 2 | DFGE | |||||
Teresa Green11 | 1 | PPTF | |||||
08:30-11:30 | WHIte, Mary | STAFF | O/V | ||||
John Smith11 | 14 | JMPD | |||||
John Smith12 | 2 | PTRA | |||||
John Smith13 | 12 | N/A | |||||
08:30-11:30 | Jimmy smith | SERVER | O/V | ||||
08:30-11:30 | Tony Starkie | SERVER | O/V | ||||
John Smith11 | 13 | RAC | |||||
11:30-13:30 | Jimmy johnston | unkown | O/V | ||||
11:30-13:30 | STUART, andy | unkown | O/V | ||||
John Smith11 | 13 | CNC | |||||
13:30-15:30 | murrey, TINA | RegSales | O/V | ||||
Bruce Lee | 14 | VGA | |||||
13:30-15:30 | HOLLY, oaks | manager | O/V | ||||
John Smith11 | 14 | 14 | |||||
13:30-15:30 | SWAN, mary | AVS | non O/V | ||||
John Smith007 | 3 | NOT | |||||
13:30-15:30 | WILLIAM, tony | unkown | O/V | ||||
John B Good 22 | 2 | F/T | |||||
Andy B Good 23 | 5 | DVDS | |||||
Mary B Good 24 | 5 | VDVD | |||||
13:30-15:30 | BBBB, James | regional manager | O/V | ||||
Harry Enfield | 2 | N/A | |||||
13:30-15:30 | Tom Jones | AVS | O/V | ||||
Robert lee | 3 | N/A | |||||
Mary Smith15 | 14 | F/T | |||||
13:30-15:30 | Nash, Ricky | CBD | O/V | ||||
Any Jones | 3 | ADFE | |||||
Freddie Merc | 5 | VBPD | |||||
13:30-15:30 | WILLIAM, R | BSD | O/V | ||||
Adam Smith | 2 | ASM | |||||
14:00-15:00 | TURNER, Tina | ASP | non O/V | ||||
Jimmy Clark | 1 | SUPS | |||||
11:30-13:30 | BBBB, James | reg_mngr | O/V | ||||
Mary Jones | 2 | N/A | |||||
<tbody> </tbody> | Tony Hanson | AVS | O/V | ||||
Gerry Devino | 3 | N/A | |||||
<tbody>
</tbody>
From the following raw csv :
Arv_Tme | Vtr_Name | Vtr_Type | V_Loc | V_Who | U_Section | W_Where |
08:30-11:30 | mary Smith | Buyer | O/V | ZZZZZZZZ | ||
08:30-11:30 | ZZZZZZZZ | John Smith04 | 13 | N/A | ||
08:30-11:30 | Tony Stark | STAFF | O/V | ZZZZZZZZ | ||
08:30-11:30 | Tony Stark | STAFF | O/V | ZZZZZZZZ | ||
08:30-11:30 | ZZZZZZZZ | John Smith04 | 3 | N/A | ||
08:30-11:30 | ZZZZZZZZ | John Smith05 | 14 | SMSDN | ||
08:30-11:30 | Fiona Jones | Sales | O/V | ZZZZZZZZ | ||
08:30-11:30 | ZZZZZZZZ | John Smith05 | 6 | VBNM | ||
08:30-11:30 | Tonia smiley | Sales_Ext | O/V | ZZZZZZZZ | ||
08:30-11:30 | Tonia smiley | Sales_Ext | O/V | ZZZZZZZZ | ||
08:30-11:30 | Tonia smiley | Sales_Ext | O/V | ZZZZZZZZ | ||
08:30-11:30 | Tonia smiley | Sales_Ext | O/V | ZZZZZZZZ | ||
08:30-11:30 | Tonia smiley | Sales_Ext | O/V | ZZZZZZZZ | ||
08:30-11:30 | Tonia smiley | Sales_Ext | O/V | ZZZZZZZZ | ||
08:30-11:30 | Tonia smiley | Sales_Ext | O/V | ZZZZZZZZ | ||
08:30-11:30 | Andy McGinty | Sales_Ext1 | O/V | ZZZZZZZZ | ||
08:30-11:30 | Andy McGinty | Sales_Ext1 | O/V | ZZZZZZZZ | ||
08:30-11:30 | Andy McGinty | Sales_Ext1 | O/V | ZZZZZZZZ | ||
08:30-11:30 | Andy McGinty | Sales_Ext1 | O/V | ZZZZZZZZ | ||
08:30-11:30 | Andy McGinty | Sales_Ext1 | O/V | ZZZZZZZZ | ||
08:30-11:30 | Andy McGinty | Sales_Ext1 | O/V | ZZZZZZZZ | ||
08:30-11:30 | Andy McGinty | Sales_Ext1 | O/V | ZZZZZZZZ | ||
08:30-11:30 | Fred West | Sales_Ext8 | O/V | ZZZZZZZZ | ||
08:30-11:30 | ZZZZZZZZ | John Smith05 | 3 | N/A | ||
08:30-11:30 | ZZZZZZZZ | Rita Smith06 | 3 | N/A | ||
08:30-11:30 | ZZZZZZZZ | Marie Smith07 | 13 | KKLS | ||
08:30-11:30 | ZZZZZZZZ | Freddie Smith08 | 14 | CBDS | ||
08:30-11:30 | ZZZZZZZZ | Tonia clark09 | 1 | RLMN | ||
08:30-11:30 | ZZZZZZZZ | Tiger Woods 007 | 2 | DFGE | ||
08:30-11:30 | ZZZZZZZZ | Teresa Green11 | 1 | PPTF | ||
08:30-11:30 | WHIte, Mary | STAFF | O/V | ZZZZZZZZ | ||
08:30-11:30 | WHIte, Mary | STAFF | O/V | ZZZZZZZZ | ||
08:30-11:30 | WHIte, Mary | STAFF | O/V | ZZZZZZZZ | ||
08:30-11:30 | ZZZZZZZZ | John Smith11 | 14 | JMPD | ||
08:30-11:30 | ZZZZZZZZ | John Smith12 | 2 | PTRA | ||
08:30-11:30 | ZZZZZZZZ | John Smith13 | 12 | N/A | ||
08:30-11:30 | jimmy smith | SERVER | O/V | ZZZZZZZZ | ||
08:30-11:30 | Tony feloney | SERVER | O/V | ZZZZZZZZ | ||
08:30-11:30 | ZZZZZZZZ | John Smith11 | 13 | RAC | ||
11:30-13:30 | Jimmy johnston | unkown | O/V | ZZZZZZZZ | ||
11:30-13:30 | STUART, andy | unkown | O/V | ZZZZZZZZ | ||
11:30-13:30 | ZZZZZZZZ | John Smith11 | 13 | CNC | ||
13:30-15:30 | murrey, TINA | RegSales | O/V | ZZZZZZZZ | ||
13:30-15:30 | ZZZZZZZZ | John Smith11 | 14 | VGA | ||
13:30-15:30 | HOLLY, oaks | manager | O/V | ZZZZZZZZ | ||
13:30-15:30 | ZZZZZZZZ | John Smith11 | 14 | 14 | ||
13:30-15:30 | SWAN, mary | AVS | non O/V | ZZZZZZZZ | ||
13:30-15:30 | ZZZZZZZZ | John Smith007 | 3 | NOT | ||
13:30-15:30 | WILLIAM, tony | unkown | O/V | ZZZZZZZZ | ||
13:30-15:30 | WILLIAM, tony | unkown | O/V | ZZZZZZZZ | ||
13:30-15:30 | WILLIAM, tony | unkown | O/V | ZZZZZZZZ | ||
13:30-15:30 | ZZZZZZZZ | John B Good 22 | 2 | F/T | ||
13:30-15:30 | ZZZZZZZZ | John B Good 23 | 5 | DVDS | ||
13:30-15:30 | ZZZZZZZZ | John B Good 24 | 5 | VDVD | ||
13:30-15:30 | BBBB, James | regional manager | O/V | ZZZZZZZZ | ||
13:30-15:30 | ZZZZZZZZ | Harry Enfield | 2 | N/A | ||
13:30-15:30 | Tom Jones | AVS | O/V | ZZZZZZZZ | ||
13:30-15:30 | Tom Jones | AVS | O/V | ZZZZZZZZ | ||
13:30-15:30 | ZZZZZZZZ | Robert lee | 3 | N/A | ||
13:30-15:30 | ZZZZZZZZ | Mary Smith15 | 14 | F/T | ||
13:30-15:30 | Nash, Ricky | CBD | O/V | ZZZZZZZZ | ||
13:30-15:30 | Nash, Ricky | CBD | O/V | ZZZZZZZZ | ||
13:30-15:30 | ZZZZZZZZ | Any Jones | 3 | ADFE | ||
13:30-15:30 | ZZZZZZZZ | Freddie Merc | 5 | VBPD | ||
13:30-15:30 | WILLIAM, R | BSD | O/V | ZZZZZZZZ | ||
13:30-15:30 | ZZZZZZZZ | Adam Smith | 2 | ASM | ||
14:00-15:00 | TURNER, Tina | ASP | non O/V | ZZZZZZZZ | ||
14:00-15:00 | ZZZZZZZZ | Jimmy Clark | 1 | SUPS | ||
11:30-13:30 | BBBB, James | reg_mngr | O/V | ZZZZZZZZ | ||
11:30-13:30 | ZZZZZZZZ | Mary Jones | 2 | N/A | ||
14:00-15:00 | Tony Hanson | AVS | O/V | ZZZZZZZZ | ||
14:00-15:00 | ZZZZZZZZ | Gerry Devino | 3 | N/A |
<tbody>
</tbody>