Group clients support requests in a table with eparate column per client

[cosima]

Please help in perhaps a easy problem, but difficult for me. My client requests are registered in a table :

Client ID ! Name ! Product ID ! Product Name ! Date ! Problem (a-z) ! Status !
22222 ! Jeff L. ! 1321 ! Nuxe ! 12-05-2015 ! c ! ? !
333 ! Jeff M. ! 1327 ! Naxe ! 14-05-2015 ! c ! Ok !
44412 ! Jeff N. ! 1312 ! Nixe ! 13-05-2015 ! c ! ? !
22222 ! Jeff L. ! 1320 ! Nyxe ! 16-05-2015 ! c ! ? !
333 ! Jeff M. ! 1327 ! Naxe ! 14-05-2015 ! c ! Ok !
44412 ! Jeff N. ! 1312 ! Nixe ! 13-05-2015 ! c ! ? !
22222 ! Jeff L. ! 1320 ! Nyxe ! 16-05-2015 ! c ! ? !

In my result table I want to get the rowid of each clients requests :

Client requests (rowId) to use with OFFSET to list client requests :

! Jeff L. ! Jeff M. ! Jeff N. !
! 1 ! 2 ! 3 !
! 4 ! 5 ! 6 !
! 7 ! ! !

The client request table have from 200 rows to 1000 and I have tried Index formulas with no success.
Please help me in creating a formula on this !


Best regards

Cosima

 

[Puertorekinsam]

How about creating a simple function in VBA

Put the following in an empty VBA module:

Function StripFirst(ClientString As Range, delm As String)
 x = ""
Strn = Split(ClientString, delm)
For i = 1 To UBound(Strn)
    x = x & Strn(i) & "!"
Next

StripFirst = Left(x, Len(x) - 1)

End Function

And then put in your cell something like this =StripFirst(A2,"!")

where the client information is in A2 and the string is delimited by "!"

 

[cosima]

Sorry for bad table data :

Client ID	Name	Product ID	Product Name	Date	Problem (a-z)	Status
22222	Jeff L.	1321	Nuxe	12-05-2015	c	?
333	Jeff M.	1327	Naxe	14-05-2015	c	Ok
44412	Jeff N.	1312	Nixe	13-05-2015	c	?
22222	Jeff L.	1320	Nyxe	16-05-2015	c	?
333	Jeff M.	1327	Naxe	14-05-2015	c	Ok
44412	Jeff N.	1312	Nixe	13-05-2015	c	?
22222	Jeff L.	1320	Nyxe	16-05-2015	c	?
In my result table I want to get the rowid of each clients requests :
Client requests (rowId) to use with OFFSET to list client requests :
Jeff L.	Jeff M.	Jeff N.
1	2	3
4	5	6
7

<colgroup><col span="5"><col><col></colgroup><tbody>
</tbody>

Hope this looks a bit better !

Cosima

 

[cosima]

Hi and thanks for your possible solution, but I have no programing experience so I hope to solve it with formulas.

Cosima