Transformationhelp

[ra20067]

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?

Column1	Column2
Name	Ra
Age	29
Gender	M
Name	Ve
Age	30
Gender	F

[camargos88 · Accepted solution]

Hi @ra20067 ,

Check this file: Download PBIX 

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

[ra20067]

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

[camargos88]

@ra20067 ,

Yes.

[ra20067]

Do i have to make any chanegs in custom column ? 

[ra20067]

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

[camargos88]

@ra20067 ,

Can you provide sample data ?

Ricardo