Hi,
I am not sure if this can be done with formulas and Excel tables, or whether I should try something in VBA. What do you think? I need help from design point of view, what do you think should be utilized.
for each id in input table
numRows = countif frequency rows + nonempty cells within matrix with valuesT
copy id numRows-times
...
Seems not efficient. What about
For i = 4 to 8
For j = 13 to N
Cells(j,2).Value = Cells(I,2).Value 'I would need to stop the macro when empty
If Cells(j,3).Value <> "" Then Cells(i,j).value = "Frequency" End if
If Cells(j,4).Value <> "" Then Cells(i,3).value = Cells(j,3).value =End if
...
Hm, I think I should firstly take care of the first two columns and only then start populating values
I am not sure if this can be done with formulas and Excel tables, or whether I should try something in VBA. What do you think? I need help from design point of view, what do you think should be utilized.
for each id in input table
numRows = countif frequency rows + nonempty cells within matrix with valuesT
copy id numRows-times
...
Seems not efficient. What about
For i = 4 to 8
For j = 13 to N
Cells(j,2).Value = Cells(I,2).Value 'I would need to stop the macro when empty
If Cells(j,3).Value <> "" Then Cells(i,j).value = "Frequency" End if
If Cells(j,4).Value <> "" Then Cells(i,3).value = Cells(j,3).value =End if
...
Hm, I think I should firstly take care of the first two columns and only then start populating values
Last edited:
