a formula to display several strings in a structured way with conditions

[richardwm]

Hello All,

I am looking for a formula or a trick to display several values (strings: phrases) in the same cell and in an organized way (I mean return to line) with 2 condtions ..

If you could help me guys, I will appreciate it even after the incarnation of my soul

Thanks in advance,

 

[AlanY]

post a sample data and desired result here so that we can have a look

 

[richardwm]

Hi AlanY, thank you for your response

In my posting permissions I may not post attachments..
Could you please communicate me your email to send you the sample?

 

[richardwm]

Here is it https://drive.google.com/file/d/0B9yhZvRAnxQoOFg5TUhFVnU5LVBTSmF4MXJSekhMdXhoUnBN/view?usp=docslist_api

 

[richardwm]

https://drive.google.com/file/d/0B9...VBTSmF4MXJSekhMdXhoUnBN/view?usp=docslist_api

 

[AlanY]

sorry, that's way beyond me.
hope you get help from others here.

 

[AlanY]

here is a solution (sort of) with helper columns F to I.
it setup for max 4 procedureNames per procedureType that can be extended.

Excel 2012
	C	D	E	F	G	H	I
2
3	Team1
4	Type	Flows	Name
5	CLIENT	0.0
6	HR MVT	0.0
7	OFFSH	11.6	CdN- Star Project ; Transfer Accounting FG (Q2 2016) ; Referential	CdN- Star Project	Transfer Accounting FG (Q2 2016)	Referential
8	PROD	0.0
9	SRVCE	0.0
10	TEMP	0.0
11	TRSF	0.0
12	Total	11.6
13
14	Team2
15	Type	Flows	Name
16	CLIENT	0.0
17	HR MVT	0.0
18	OFFSH	0.0
19	PROD	0.0
20	SRVCE	0.0
21	TEMP	0.0
22	TRSF	12.0	Activity Integration	Activity Integration
23	Total	12.0
24
Feuil3

Cell Formulas
Range	Formula
E5	=SUBSTITUTE(SUBSTITUTE(TRIM(SUBSTITUTE(SUBSTITUTE(F5&"@"&G5&"@"&H5&"@"&I5," ","#"),"@"," "))," "," ; "),"#"," ")
F16	{=IFERROR(INDEX('data sample'!$B$1:$B$100,SMALL(IF((('data sample'!$C$1:$C$100=$C16)*('data sample'!$D$1:$D$100=Feuil3!$C$14)),ROW($F$1:$F$100)),COLUMN(F$1)-COLUMN($E$1)),1),"")}
F5	{=IFERROR(INDEX('data sample'!$B$1:$B$100,SMALL(IF((('data sample'!$C$1:$C$100=$C5)*('data sample'!$D$1:$D$100=Feuil3!$C$3)),ROW($F$1:$F$100)),COLUMN(F$1)-COLUMN($E$1)),1),"")}
Press CTRL+SHIFT+ENTER to enter array formulas.