Forum Discussion

10 Replies

  • AlB's avatar
    AlB
    Community Champion
    7 years ago

    Hi cham

    II'm going to venture that you need to use "Use First Row as Headers" under the Home tab in the query editor

    • cham's avatar
      cham
      Post Patron
      7 years ago

      Hi,

       

      Can't use that feature becuase some column names are alredy in the header.

    • cham's avatar
      cham
      Post Patron
      7 years ago

      Hi,

       

      Can't use that feature becuase some column names are alredy in the header.

  • HotChilli's avatar
    HotChilli
    Community Champion
    7 years ago

    Using Power Query Editor,

    Transpose the table,

    Merge the 2 columns (tidy your data as required to get the headings you want),

    Transpose the table,

    Promote first row as headers

    • cham's avatar
      cham
      Post Patron
      7 years ago

      HotChilliHi,

       

      I'm not clear with your solution. Could you please explain me again? I have more than one column like this issue.