Forum Discussion

cham's avatar
cham
Post Patron
7 years ago
Solved

Rname column names

Hi,   I want to change my column names. I have my column names in two rows as below, So i want to get it into the one row.  
Need Help
Show and Tell
Tips and Tricks
  • HotChilli's avatar
    HotChilli
    7 years ago

    Which part is not clear?

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.

    • HotChilli's avatar
      HotChilli
      Community Champion
      7 years ago

      Which part is not clear?

      • cham's avatar
        cham
        Post Patron
        7 years ago

        When transpose the table, column names in the first row is desapier. How can i get the table name uisng transose? Also i'm not clear with merging.