Forum Discussion

office 365 office 365's avatar
office 365 office 365
Copper Contributor
Nov 16, 2018
Solved

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...
excel
Formulas and Functions
office 365
  • Jamil's avatar
    Jamil
    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.

     

     

Jamil's avatar
Jamil
Bronze Contributor
Nov 16, 2018

from Detlef's attachment you can see that it can be done using power query and If you could not figures it out from the applied steps in PQ and you are wondering how he has done it.  Attached is the video that demonstrates how it is done in Power Query.

office 365 office 365's avatar
office 365 office 365
Copper Contributor
Nov 19, 2018
Amazing feedback from you guys. I will study base on your suggestion. Thank you very much

Resources