Forum Discussion
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?
| Column1 | Column2 |
| Name | Ra |
| Age | 29 |
| Gender | M |
| Name | Ve |
| Age | 30 |
| Gender | F |
Hi Anonymous ,
Check this file: Download PBIX
Did I answer your question? Mark my post as a solution!
Ricardo
6 Replies
Hi Anonymous ,
Check this file: Download PBIX
Did I answer your question? Mark my post as a solution!
RicardoAnonymous ,
Yes.