Forum Discussion

Icon for Post Patron rank

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.

Tips and Tricks

HotChilli
7 years ago
Which part is not clear?

Icon for Community Champion rank

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
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
  Community Champion
  7 years ago
  Which part is not clear?
  - 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.