Extract data from table

[numaiu]

Hello everyone.

I have the following table with materials that will be shipped in multiple deliveries:

Material	Pieces delivery 1	Pieces delivery2	Pieces delivery3
A	2	1	0
B	4	0	0
C	0	15	8
D	6	16	5

I want to make a dynamic table for each delivery, that can change according to the number of pieces, and skip the rows with "0" :

Delivery 1 table

Material	Pieces
A	2
B	4
D	6

Delivery 2 table

Material	Pieces
A	1
C	15
D	16

Delivery 3 table

Material	Pieces
C	8
D	5

Thanks in advance

 

[mart37]

Use a Pivot Table.