Forum Discussion
Unpivoting?
Hi all! I've been scratching my head with the following modeling issue... I am importing a Sharepoint List of employees located in different sites... The structure of this list is: - one site per ro...
Anonymous
Hi, Try with a combination of Unpivot & Pivot.
Check the PBIX.
PD: If you want to mantain the Staff 1,2,3...
Do This:
Regards
Victor
Unpivot should get you real close. Using a sample dummy set I selected all non-site columns and click unpivot. Viola!
In query editor
Result:
Hi Aron,
thx for your input, but it doesn't solve the issue I'm afraid, as this puts for instance for Staff1 the attributes in different rows, whereas we want them in column... :(
Anonymous
Hi, Try with a combination of Unpivot & Pivot.
Check the PBIX.
PD: If you want to mantain the Staff 1,2,3...
Do This:
Regards
Victor
Vvelarde, this is exactly it, thx!!!!!!!