I have the task of looking at a certain column in Excel and if that column is unique compared to the rest of the column, that entire row needs to be duplicated by 12. Does anyone have any idea on the best way to approach this? I have been able to create a datatable of the unique values in the column, but now I need to add the other columns back to these rows, and duplicate each row 12 times. I know this is confusing, thanks in advance
Simple solution is copy the row if your condition is true and append the row within same file 11 times using Do-While loop or while loop.
Hope it helps.