KristinaElise
New Member
- Joined
- May 31, 2012
- Messages
- 12
I've got a sheet that has multiple columns with various values in each. There are also multiple rows. , for example
Apples Oranges Pears Bananas
Man1 1 0 1 0
Man2 1 1 0 1
Man3 1 0 1 0
Man4 0 1 1 1
I need to create a value for each row that represents how many people want each fruit--where 1 means yes and 0 means no. I need the row to say, for example for Man 1
Apples, Pears
Is there a way to do this so that I can have commas, etc. all in the right place? obviously the values would be different for each row.
Alos, while this example shows only 4 columns, there are actually 20 and there are about 50000 rows.
Any help would be greatly appreciated.
Apples Oranges Pears Bananas
Man1 1 0 1 0
Man2 1 1 0 1
Man3 1 0 1 0
Man4 0 1 1 1
I need to create a value for each row that represents how many people want each fruit--where 1 means yes and 0 means no. I need the row to say, for example for Man 1
Apples, Pears
Is there a way to do this so that I can have commas, etc. all in the right place? obviously the values would be different for each row.
Alos, while this example shows only 4 columns, there are actually 20 and there are about 50000 rows.
Any help would be greatly appreciated.