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.

     

     

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