Good day!
Tell me, please, how to use a Power BI interface to transpose a table in a specific way?
For example, there is a table
Count | Year | Office No. | Sign
A1 | 2017 | 1 | YES
A2 | 2018 | 2 | NO
....
AN | 2018 | N | YES
it needs to be converted to a table
Count | Year | Office No. 1 | Office No. 2 | ... | Office No. N |
A1 | 2017 | YES | | | |
A2 | 2018 | | NO | | ... | | |
...
AN | 2018 | | | ... | YES |
Those. you need to select the values of the column No. of the Office of the source table in separate columns, and put on them the appropriate sign.
