Forum Discussion
Many columns in one
Hi guys, how are u?
i'm having problem to transform this:
| Name | Project | DevOps | Digital | Host | Net |
| Thiago | X | 2 | 2 | ||
| John | y | 1 | 3 | ||
| Max | z | 2 | 1 |
into
| Name | Project | Qt |
| Thiago | x | Digital |
| Thiago | x | Digital |
| Thiago | x | DevOps |
| Thiago | x | DevOps |
| John | y | Digital |
| John | y | Net |
| John | y | Net |
| John | y | Net |
| Max | z | DevOps |
| Max | z | DevOps |
| Max | z | Host |
is that possible?
Anonymous go to query editor, select name and project columns, right click and choose unpivot other columns
1 Reply
Anonymous go to query editor, select name and project columns, right click and choose unpivot other columns