Hi, in the attached I have an export from JIRA that has some repeated columns label, label2, label3 and Comment, Comment4, Comment5 these two Label and Comment can be bigger that just 3 examples but the current export happens to just have 3 of each.
I have some code already that will merge the data of the comments with a line break into a single cell after selecting the columns that are similar:
Formula:Please Login or Register to view this content.
I could do this for labels as well as it is based on a manual selection, however I would like to automate this.
I also have the following that creates a table of the exported data and hides columns we don't care about for the purpose of presenting this data, but we don't want to lose hence only hiding columns.
Formula:Please Login or Register to view this content.
I have some basic idea of working with tables but I cant get into my head how to search for the headers that start Labels and get their numbers to then select and use the merge code I already have on them. then repeat with the comments ones.
attached is an example of the data from JIRA.
Bookmarks