cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cham Member
Member

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.

 

column name error.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
HotChilli New Contributor
New Contributor

Re: Rname column names

Which part is not clear?

10 REPLIES 10
Super User
Super User

Re: Rname column names

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 Member
Member

Re: Rname column names

Hi,

 

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

cham Member
Member

Re: Rname column names

Hi,

 

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

HotChilli New Contributor
New Contributor

Re: Rname column names

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 Member
Member

Re: Rname column names

@HotChilliHi,

 

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

HotChilli New Contributor
New Contributor

Re: Rname column names

Which part is not clear?

cham Member
Member

Re: Rname column names

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.

HotChilli New Contributor
New Contributor

Re: Rname column names

If you follow my recipe, the transpose must be the first thing you do to your data set.  Remove any 'promote headers' before this.

If you have succesfully transposed the table, the first two columns will have all the proposed headers (and also null values).  You must then select the first two columns and click 'merge columns'.  Some of the values in this column will be perfect for you and others won't.  Only you can decide.  So you perform more transforms as required to get names you want.  You then transpose the table again and then promote headers. 

 

If you can't do any of that because it is too complex or not worth the effort then, using your example picture, rename the columns you want to change by hand and remove the first row

cham Member
Member

Re: Rname column names

Could you please explain me the merging process. I did transpose table and merge, then the merge columns are coming like as follwing, This is not right

 

merging.PNG

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 22 members 975 guests
Please welcome our newest community members: