Hi sorry that my data is not in XL2BB but I still have not figured out why it stopped working on my PC.
I am trying to figure out how to create a button that would combine rows B-F dependent on the duplicate values in column B into a single row in columns H-M, but also I want the code to count the total number of times the value in column B is duplicated into another column labeled "# Blocks" in column I.
I have not been able to find any tutorials on how to do this.
Note: (column B data is created by the formula =LEFT(A2,MIN(--(FIND(CHAR(ROW($65:$90)),A2&CHAR(ROW($65:$90)),3)))-1) with data taken from column A).
I want to take the initial data
and condense it into this format
I am trying to figure out how to create a button that would combine rows B-F dependent on the duplicate values in column B into a single row in columns H-M, but also I want the code to count the total number of times the value in column B is duplicated into another column labeled "# Blocks" in column I.
I have not been able to find any tutorials on how to do this.
Note: (column B data is created by the formula =LEFT(A2,MIN(--(FIND(CHAR(ROW($65:$90)),A2&CHAR(ROW($65:$90)),3)))-1) with data taken from column A).
I want to take the initial data
and condense it into this format