hi all
I'm using Power Query for first time after having watched some videos on Youtube.
I'm trying to load and combine a number of Excel files using 'From Folder' by following the steps in this video: https://www.youtube.com/watch?v=a7E29H5ZUmE, but when I reach the step at 2:25, my screen looks different.
In 2:25 he is expanding the data into 4 different columns: Name, Data, Item and Kind.
When I do this, I only get 'Name' and 'Data'.
Would anyone know what I am doing wrong?
Also, if you have any recommendations on how to learn Power Query that would be great too!
Thanks in advance for the help
Bart
I'm using Power Query for first time after having watched some videos on Youtube.
I'm trying to load and combine a number of Excel files using 'From Folder' by following the steps in this video: https://www.youtube.com/watch?v=a7E29H5ZUmE, but when I reach the step at 2:25, my screen looks different.
In 2:25 he is expanding the data into 4 different columns: Name, Data, Item and Kind.
When I do this, I only get 'Name' and 'Data'.
Would anyone know what I am doing wrong?
Also, if you have any recommendations on how to learn Power Query that would be great too!
Thanks in advance for the help
Bart