Forum Discussion
office 365 office 365
Nov 16, 2018Copper Contributor
DATA RESTRUCTURING USING EXCEL
Hi Excel Community, i'm using Office 365. i want to manage my data using excel. below is my sample data. Paper Numb Speaker 1 Name Speaker 1 Country Speaker 2 Name Speaker 2 Country Spe...
- Nov 19, 2018
وعليكم السلام
I have recorded a video for you that demonstrates the use of power query to transform your data.
Please see attached video.
Detlef_Lewin
Nov 16, 2018Silver Contributor
Hi
First unpivot, then pivot.
Done with Power Query.
office 365 office 365
Nov 19, 2018Copper Contributor
Amazing feedback from you guys. I will study base on your suggestion. Thank you very much