cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Betigolo Regular Visitor
Regular Visitor

matrix to table help

Hi,

 

I need your help.

 

How to transform the following table:

 

Name  |  Course1 | Course 2 | Course 3|

A         |  YES        |    YES       | NO         |

B         |   NO        |    NO       |  YES       |

C         |   NO        |     YES     |   NO       |

 

In to :

 

Name   |  Course     | mandatory

A          |   Course1  |    YES

A          |   Course2  |    YES

A          |  Course 3  |    NO

B          |  Course 1  |    NO

B          |  Course 2  |    NO 

B          |   Course 3 |    YES

         |   Course 1 |    NO

C          |   Course2  |    YES

C          |  Course 3  |    NO

 

Or

 

Name   |  Course     | mandatory

A          |   Course1  |      YES

A          |   Course2  |     YES

 

B          |   Course 3 |      YES

C          |   Course2  |     YES

 

 

Or

Name   |  Course     | 

A          |   Course1  |      

A          |   Course2  |     

B          |   Course 3 |      

C          |   Course2  |     

 

Many thanks for your help

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: matrix to table help

@Betigolo,

 

You may right click Name column and select Unpivot Other Columns in Query Editor.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: matrix to table help

@Betigolo,

 

You may right click Name column and select Unpivot Other Columns in Query Editor.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.