Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
ra20067
Helper I
Helper I

Transformationhelp

 

I have excel file with this format where in one colum values are repeating. I have attached an example below. I want to use column1 values as column header but not repeated column. values in column1 are reapting and that is creating issue. Could anyone please help?

Column1Column2
NameRa
Age29
GenderM
NameVe
Age30
GenderF
1 ACCEPTED SOLUTION
camargos88
Community Champion
Community Champion

Hi @ra20067 ,

 

Check this file: Download PBIX 

 

 

Did I answer your question? Mark my post as a solution!
Ricardo



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



View solution in original post

6 REPLIES 6
camargos88
Community Champion
Community Champion

Hi @ra20067 ,

 

Check this file: Download PBIX 

 

 

Did I answer your question? Mark my post as a solution!
Ricardo



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



Thanks for the solution. In my data i have more than 20 columns. Can i use the same approch ?

@ra20067 ,

 

Yes.



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



Do i have to make any chanegs in custom column ? 

Also in my case index are not coming as 1 2 1 2 .  it is coming as 1 2 3 4...

@ra20067 ,

 

Can you provide sample data ?

 

Ricardo



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors