solidla.blogg.se

How to merge duplicate rows in excel without losing data
How to merge duplicate rows in excel without losing data













how to merge duplicate rows in excel without losing data

Duplicates cannot be removed as there is data in other rows which is required. When I tried to extract values, it gives me error so I have to expand it to new rows which create duplicates in column - 'key'. Most of the projects are using fix versions and versions field where few projects are using other 4 fields.Īs you can see all these 6 columns are list or records. Release Information.įor all JIRA projects in my report, I derived that following 6 fields are used (shown in screenshot).

how to merge duplicate rows in excel without losing data

The only problem here is one field which is not used in a harmonized way for across all JIRA projects and i.e. I am working on Power BI project where I am fetching data from many JIRA projects.















How to merge duplicate rows in excel without losing data