Forum Discussion

jimmybi's avatar
jimmybi
Frequent Visitor
8 years ago

Unpivot and append dynamically multiple columns

Hi guys,   I need a bit of Power Query magic. I have data from Excel files that has data for around many devices with time stamp. It looks something like this:   Timestamp    DeviceName EmptyColu...
Need Help
Tips and Tricks
Tutorial Requests
  • jimmybi's avatar
    jimmybi
    Frequent Visitor
    7 years ago

    Hi Cherie,

     

    I saw those links and they are useful. That is where I got the List.Alternate idea from. However since I am using a folder as a source it gives me the folder column names. I tried to use them in the Advanced editor for the sample file and this is what I get: 

    Edit Queries Snapshot

    And this is my M code:

     

    So my problem is where to get the list from at the moment. Any ideas?