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

السلام عليكم

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