Boanerges_0800
New Member
- Joined
- Feb 22, 2012
- Messages
- 17
I have a list of data that has persons employee number and names in the columns A:B and activities they participated in row 1 (ex: C1- hiking, D1-running, E1-skating, F1-walking, and H1-lifting) listed across the top of the spreadsheet. Starting in cell C2, each person could have any combination of activities listed with their name and number including none. </SPAN>
[TABLE="width: 897"]
<TBODY>[TR]
[TD][/TD]
[TD]A</SPAN>
[/TD]
[TD]B</SPAN>
[/TD]
[TD]C</SPAN>
[/TD]
[TD]D</SPAN>
[/TD]
[TD]E</SPAN>
[/TD]
[TD]F</SPAN>
[/TD]
[TD]G</SPAN>
[/TD]
[TD]H</SPAN>
[/TD]
[TD]I</SPAN>
[/TD]
[TD]J</SPAN>
[/TD]
[TD]K</SPAN>
[/TD]
[TD]L</SPAN>
[/TD]
[/TR]
[TR]
[TD="align: right"]1</SPAN>
[/TD]
[TD]Num</SPAN>
[/TD]
[TD]Nam</SPAN>
[/TD]
[TD]Hiking</SPAN>
[/TD]
[TD]Running</SPAN>
[/TD]
[TD]Skating </SPAN>
[/TD]
[TD]Walking</SPAN>
[/TD]
[TD]Lifting</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2</SPAN>
[/TD]
[TD="align: right"]123</SPAN>
[/TD]
[TD]John J</SPAN>
[/TD]
[TD]Hiking</SPAN>
[/TD]
[TD]Running</SPAN>
[/TD]
[TD][/TD]
[TD]Walking</SPAN>
[/TD]
[TD][/TD]
[TD]Hiking</SPAN>
[/TD]
[TD]Running</SPAN>
[/TD]
[TD]Walking</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3</SPAN>
[/TD]
[TD="align: right"]459</SPAN>
[/TD]
[TD]Susan B</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Skating </SPAN>
[/TD]
[TD]</SPAN>
[/TD]
[TD]Lifting</SPAN>
[/TD]
[TD]Skating </SPAN>
[/TD]
[TD]</SPAN>Lifting
[/TD]
[TD]</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]
I want excel to summarize text found in Columns C-H and enter it into columns H,I,J,K,L skipping any blanks. For example if John J’s data was Hiking, Running & Walking than the result would be H2-Hiking,I2-Running & J2-Walking. If Susan B’s data was Skating and Lifting then the result would be H3-Skating, I3-Lifting, and columns J-L would be blank.
Thanks for your help. I am using Excel 2010</SPAN>
[TABLE="width: 897"]
<TBODY>[TR]
[TD][/TD]
[TD]A</SPAN>
[/TD]
[TD]B</SPAN>
[/TD]
[TD]C</SPAN>
[/TD]
[TD]D</SPAN>
[/TD]
[TD]E</SPAN>
[/TD]
[TD]F</SPAN>
[/TD]
[TD]G</SPAN>
[/TD]
[TD]H</SPAN>
[/TD]
[TD]I</SPAN>
[/TD]
[TD]J</SPAN>
[/TD]
[TD]K</SPAN>
[/TD]
[TD]L</SPAN>
[/TD]
[/TR]
[TR]
[TD="align: right"]1</SPAN>
[/TD]
[TD]Num</SPAN>
[/TD]
[TD]Nam</SPAN>
[/TD]
[TD]Hiking</SPAN>
[/TD]
[TD]Running</SPAN>
[/TD]
[TD]Skating </SPAN>
[/TD]
[TD]Walking</SPAN>
[/TD]
[TD]Lifting</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2</SPAN>
[/TD]
[TD="align: right"]123</SPAN>
[/TD]
[TD]John J</SPAN>
[/TD]
[TD]Hiking</SPAN>
[/TD]
[TD]Running</SPAN>
[/TD]
[TD][/TD]
[TD]Walking</SPAN>
[/TD]
[TD][/TD]
[TD]Hiking</SPAN>
[/TD]
[TD]Running</SPAN>
[/TD]
[TD]Walking</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3</SPAN>
[/TD]
[TD="align: right"]459</SPAN>
[/TD]
[TD]Susan B</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Skating </SPAN>
[/TD]
[TD]</SPAN>
[/TD]
[TD]Lifting</SPAN>
[/TD]
[TD]Skating </SPAN>
[/TD]
[TD]</SPAN>Lifting
[/TD]
[TD]</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]
I want excel to summarize text found in Columns C-H and enter it into columns H,I,J,K,L skipping any blanks. For example if John J’s data was Hiking, Running & Walking than the result would be H2-Hiking,I2-Running & J2-Walking. If Susan B’s data was Skating and Lifting then the result would be H3-Skating, I3-Lifting, and columns J-L would be blank.
Thanks for your help. I am using Excel 2010</SPAN>