Disappearing values after Unpivot Table

[FilipeSantos_pt]

Hello, 

I am trying to do the following Unpivot:
I select column A (Supplier) and B (Doc Number) and I select Unpivot other columns.

So the final result is Supplier, Doc Number, Invoice Type and Value. However, when I do this the first, for example, 600 rows referring to column B (Doc Number) disappears. Can anyone help this newbie to understant what I am doing wrong? Thank you.

 A                 B                        C                  D                   E                     F                 G
Supplier        Doc Number  Invoice Tran  Invoice Ins    Invoice DT   Invoice FRG   Invoice AT

Sup1	RS/21	12B	13B	12B	14B	null
Sup1	RS/22	null	null	20C	null	null
Sup2	XPTO/1	BG-12	BG-1	BG-13	BG-14	BG-15
Sup2	XPTO/1	CP-13	CP-14	CP-15	CP-16	CP-17

[camargos88 · Accepted solution]

@FilipeSantos_pt ,

You need to replace the null with some value that can be replaced to null later.

When you unpivot null values, it is removed from the dataset.

[FilipeSantos_pt]

Thank you. 

I had to add a Dummy column with values for the lines that a had new Doc Number but have yet to receive invoices not to disappear