Hi guys, i need to create some lists from an excel file.
In my excel in a column “A” there are numbers that give me the right order of my bill of materials and in “B” the relative codes.
That number, in a integer indicate the main code and in a decimal the children of the main code.
In this example the main code 2 in Column “A” have the code in “B” SGA30050070.
I need to create a list automatically to get the main code SGA30050070 and all the children. In this case
2.1 - SGE30050071
2.2 - SGE30050072
for all of elements of my excel file.
In this case i attach an excel example to understand better what i need, but sometimes the code in my excel BOM are thousand and thousand.
I want to get the B value only. But the list is from A numbers.
Again, wait i’m trying to explain better.
In column B ive the code of components, but the hierarchy is from column A.
Column A say me who is the “father” and who is the children.
If in column A there is a integer number, is a father.
If there is a decimal number, is a children. But the family is indicate from integer number!
if integer number is 2 (and relative code in column B is ASM30050070) and childrens are 2.1 and 2.2 (and relative code in columb B are SGE30050071 and SLE30050072) i want a list which contains The code of number 2 and the codes of numbers 2.1 and 2.2