Forum Discussion

Oliehoek's avatar
Oliehoek
Frequent Visitor
3 years ago
Solved

Convert a cell into a column entry in power query

Hi,   I am uploading data from daily spreadsheets and the sheet has several tables in them. The first cell of the table is giving me the area the table is referring to and then the data, below this...
  • serpiva64's avatar
    3 years ago

    Hi,

    You can obtain this result with the steps of the attached file

    Then it is not so clear for me what you need next.

    If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!

     

  • Oliehoek's avatar
    Oliehoek
    3 years ago

    Thanks!

    It is the "Fill > Down" option that I was not aware of.