Filtering and separating the data from the range of cells

[sekar]

Hi.,

I have the table (first one) like this as below.
the data before the "-"(16mm_BWR_ply-) are type of boards with thickness and data after "-" (-Offwhite_Offwhite) are type of laminates. I want to segregate the qty of boards and laminates separately.

if the cell is like "16mm_BWR_ply-Offwhite_Offwhite", the qty of the offwhite (laminate) (second table) has to be changed as 2 instead of 1, as since offwhite laminate are used on both side of the boards, hence the qty is 2. This condition applies to all the cells, if the laminate 21091HGL / 21091SF (SF & HGL are different) are on bothsides.

Also the laminate names will vary not restricted to the three types (sample data)

i want the data to be segregated as below (second table).

How to approach this problem.? and How to separate?

Untitlesdfdfgff.xlsx
	A	B	C	D
1	material	length	width	Qty
2	16mm_BWR_ply-Offwhite_Offwhite	684	100	1
3	16mm_BWR_ply-Offwhite_Offwhite	720	550	1
4	16mm_BWR_ply-Offwhite_Offwhite	700	550	1
5	3.5mm_BWR_Ply-Offwhite_Offwhite	700	700	1
6	3.5mm_BWR_Ply-Offwhite_Offwhite	680	480	1
7	16mm_HDHMR-21091SF_21091SF	718	148	1
8	16mm_HDHMR-Offwhite_21091SF	718	418	1
9	16mm_HDHMR-Offwhite_21091SF	718	148	1
10	16mm_HDHMR-Offwhite_21091HGL	698	498	1
11	16mm_HDHMR-21091HGL_21091HGL	698	398	1
12	16mm_HDHMR-21091HGL_21091HGL	698	398	1
13	3.5mm_BWR_Ply-Offwhite_Offwhite	764	100	1
14	3.5mm_BWR_Ply-Offwhite_Offwhite	764	100	1
15
16
17
18	Material	Length	Width	Qty
19	16mm_BWR_ply	684	100	1
20	16mm_BWR_ply	720	550	1
21	16mm_BWR_ply	700	550	1
22	3.5mm_BWR_Ply	700	700	1
23	3.5mm_BWR_Ply	680	480	1
24	3.5mm_BWR_Ply	764	100	1
25	3.5mm_BWR_Ply	764	100	1
26	16mm_HDHMR	718	148	1
27	16mm_HDHMR	718	418	1
28	16mm_HDHMR	718	148	1
29	16mm_HDHMR	698	498	1
30	16mm_HDHMR	698	398	1
31	16mm_HDHMR	698	398	1
32	Offwhite	684	100	2
33	Offwhite	720	550	2
34	Offwhite	700	550	2
35	Offwhite	700	700	2
36	Offwhite	718	418	1
37	Offwhite	718	148	1
38	Offwhite	698	498	1
39	Offwhite	764	100	2
40	Offwhite	764	100	2
41	21091SF	718	148	2
42	21091SF	718	418	1
43	21091SF	718	148	1
44	21091HGL	698	498	1
45	21091HGL	698	398	2
46	21091HGL	698	398	2
Data (2)