Hello, thanks in advance for your help.
I am using Jira and the export file has multiple columns of the same header name. I can't find a way to get around the Warning that multiple fields name in the input file There was a post using the Dynamic Rename tool but it only works on the header but not the first row which contains the header name (at least my understanding). Keep in mind that there can be any number of "Type" columns.
I will be transposing the data anyway so I was thinking of renaming the "Type" columns to "Type" with number since there's no telling of how many "Type" columns the file will have. After the transpose I no longer need the "Type" header
Input:
| ID | Title | Type | Type | Type | Type |
| 1 | Title1 | A | | | |
| 2 | Title2 | A | B | | |
| 3 | Title3 | B | C | D | E |
After Transpose:
| ID | Name | Value |
| 1 | Title1 | A |
| 2 | Title2 | A |
| 2 | Title2 | B |
| 3 | Title3 | B |
| 3 | Title3 | C |
| 3 | Title3 | D |
| 3 | Title3 | E |
