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

Thanks a lot Jamil. its working. i'm really appreciate your effort to make tutorial video for me. may you successful in your life journey. 

  • Jamil's avatar
    Jamil
    Bronze Contributor
    Nov 19, 2018
    You are welcome. Thanks for your feedback.
    • office 365 office 365's avatar
      office 365 office 365
      Copper Contributor
      Nov 19, 2018

      السلام عليكم

      Dear Jamil.

      i having another problem to manage multiple column to restructure format database.

      please find the attachment for your reference. 

      for your information, 

       

      below details is one variable (Role)

      Organizer
      Chair
      Discussant 1
      Discussant 2
      Speaker 1
      Speaker 2
      Speaker 3
      Speaker 4
      Speaker 5
      Speaker 6
      Speaker 7
      Speaker 8
      Speaker 9

       

      appreciate if you can help me 

       

      • Jamil's avatar
        Jamil
        Bronze Contributor
        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.

         

         

Resources