Collecting variable data from several columns

[RaudMees]

Hello

I need some help with collecting data. Excel link here (site can be not secure, but it is) https://tehnik.ee/Edges.xlsx
This file will be filled from CAD export, only header is fixed on top. I am creating a template file for export with sorting data etc, but stucked with edgebandings total length.

Columns edge1...edge4 have edgebandings names and they are variables, up to 200 different names can be there. Also they can be mixed like in sample and some cells are blank.
I need to get total length for each edgebandings type as on Result sheet.
I can add all possible edgebanding names to code if needed to make it more functional.

Any good ideas?

RaudMees

 

[RaudMees]

This case is solved!

 

[smozgur]

Good to hear the case is solved.

If you would like to post the solution then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.