Summary of cells.

[Madcat]

G'day guys,

Thanks for taking the time at looking at my request.

How do I make the following cells:

Player           FB  WI  CE
FERGUSON, Blake	  2  18   1

Into

FERGUSON, Blake FB, WI, CE

Cheers
Madcat

 

[Madcat]

G'day guys,

Thanks for taking the time at looking at my request.

How do I make the following cells:

Player           FB  WI  CE
FERGUSON, Blake	  2  18   1

Into

FERGUSON, Blake FB, WI, CE

Cheers
Madcat

Could someone please have a look at this for me?

 

[Madcat]

Any body? Please?

 

[MrVillareal]

Hi please provide your data source and your expected output.

 

[Madcat]

Hi please provide your data source and your expected output.

A                  B   C   D
1 Player           FB  WI  CE
2 FERGUSON, Blake   2  18   1

The data is Blake Ferguson has played 2 games at FB [Fullback], 18 at WI [Wing] and 1 at CE [Centre].

I need to summarize this data in one cell e.g FB, WI, CE

Thank you very much MrVillareal.

 

[Madcat]

Anybody?

 

[MrVillareal]

Is this what you want?

Excel Workbook
	A	B	C	D
1	Player	FB	WI	CE
2	FERGUSON, Blake	2	18	1
3
4	FERGUSON, Blake FB, WI, CE
Sheet4

Excel 2010

Cell Formulas
Range	Formula
A4	=A2&" "&B1&", "&C1&", "&D1

Are there any results you expect? If possible pls provide all possible results, data source, and conditions.

 

[Madcat]

Is this what you want?

Excel Workbook
	A	B	C	D
1	Player	FB	WI	CE
2	FERGUSON, Blake	2	18	1
3
4	FERGUSON, Blake FB, WI, CE
Sheet4

Excel 2010

Cell Formulas
Range	Formula
A4	=A2&" "&B1&", "&C1&", "&D1

Are there any results you expect? If possible pls provide all possible results, data source, and conditions.

Thanks again for the reply MrVillareal. I was hoping to get the positions in the cell next to FERGUSON, Blake

 

[Madcat]

Thanks again for the reply MrVillareal. I was hoping to get the positions in the cell next to FERGUSON, Blake

Round                   FB 	 WI 	 CE 	 FE 	 HB 	 PR 	 HK 	 SR 	 LK 
ZILLMAN, William         7 	 -   	 4 	 10 	 -   	 -   	 -   	 -   	 -   
GORDON, Kevin            -   	 2 	 -   	 -   	 -   	 -   	 -   	 -   	 -   
MICHAELS, Steve          -   	 17 	 3 	 -   	 -   	 -   	 -   	 -   	 -

In summary

ZILLMAN, William  FB, CE, FE
GORDON, Kevin     WI
MICHAEL, Steve    WI, CE

 

[Madcat]

Thanks again for the reply MrVillareal. I was hoping to get the positions in the cell next to FERGUSON, Blake

Round                   FB 	 WI 	 CE 	 FE 	 HB 	 PR 	 HK 	 SR 	 LK 
ZILLMAN, William         7 	 -   	 4 	 10 	 -   	 -   	 -   	 -   	 -   
GORDON, Kevin            -   	 2 	 -   	 -   	 -   	 -   	 -   	 -   	 -   
MICHAELS, Steve          -   	 17 	 3 	 -   	 -   	 -   	 -   	 -   	 -

In summary

ZILLMAN, William  FB, CE, FE
GORDON, Kevin     WI
MICHAEL, Steve    WI, CE

Can someone please help?