Power Query the best way?

[AndyH100]

Hi, I'm trying to combine several lines of data into one row where the data to combine is for the same student and if there is a 1 anywhere in the subsequent columns a one is recorded in that column.
The raw data:

I have tried to combine the data using Power Query -

I have had a look at a couple of tutorials and I can't work out how to get the following for example:
David May 0, 0, 0 etc.
Bruce Bay 1, 1, 0 etc.
Penny Top 1, 0, 0 etc.
Dave Trill 0, 0, 0 etc.

How do you merge/combine across multiple columns or am I tackling this the wrong way?

Thanks,

Andy.

 

[Bo_Ry]

Start from Group by

Click advanced
1. New column name: …ADD1 operation: Sum Column …ADD1
2. click add aggregation
repeat step 1,2 but change to the next column

 

[AndyH100]

Thanks Bo_Ry - I have over 150 columns - there isn't a maximum number of columns you can add is there?

 

[Bo_Ry]

Start from Source,
1. Select column Name > right-click > Unpivot other columns
2. Select column Attribute > Ribbon Transfrom > Pivot column Values column > Select Values

 

[AndyH100]

Thanks again Bo_Ry but I can't find Ribbon Transform?

 

[AndyH100]

Sorry I have found it now.