Hi PBI community,
I want to create a new column that takes values from 5 different columns and puts them into 1 column, but I do not want the 5 values in the same cell. I want them to each have their own row. I pretty much want any level of manager to be able to see any employee that falls under them when they filter for their name, not just their direct reports but everyone reporting to people underneath them. I hope I articulated this well enough. I know you can use LOOKUPVALUE to bring in a new column, but I want to do that for multiple values without concatenating.
For example:
Table
| Employee | Level 1 Manager | Level 2 Manager | Level 3 Manager | Level 4 Manager | Level 5 Manager |
| John Smith | Jessica Johnson | Henry Williams | Greg Cox | Fred Marks | Larry Walter |
| Kelly Ann | John Martin | Bill Finn | Sam Berk | Ashley Bensen | Barbara Hurst |
What I want the resulting table to look like:
| Employee | Manager |
| John Smith | Jessica Johnson |
| John Smith | Henry Williams |
| John Smith | Greg Cox |
| John Smith | Fred Marks |
| John Smith | Larry Walter |
| Kelly Ann | John Martin |
| Kelly Ann | Bill Finn |
| Kelly Ann | Sam Berk |
| Kelly Ann | Ashley Bensen |
| Kelly Ann | Barbara Hurst |
