Stationary Provisioning based on month

[venkatvedavyasan]

Hi,

I'm trying to prepare a inventory which is quite big of which I have given a sample below.

I have a data month wise where it says what item is provided to the department on which month

Poduct	April	May	June	July	August
Pen	G	NG	G	NA	NA
Eraser	NG	NA	NA	G	G
Paper	G	NA	G	NG	NA
Paper clip	NG	NA	NG	G	NA

I want the day to be in two column data like below.

Prduct	Month	Given	NotGiven
Pen	April	Given
Pen	May		Not Given
Pen	June	Given
Eraser	April		Not Given
Eraser	July	Given
Eraser	August	Given
Paper	April	Given
Paper	June	Given
Paper	July		Not Given
Paper Clip	April		Not Given
Paper Clip	June		Not Given
Paper Clip	July	Given

I tried Transpose but I'm not getting the option repeated. For example Pen was given in April and June and given in May, but I get only April.

I don't have access to Macros so let me if we can achieve this through some formula or BI

[#2]

@venkatvedavyasan 

You can try Power Query. In the attached file you can add data to the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.

The data layout in the screenshot and in the attached file is for illustration. You can place the green result table to the right of the blue table or in another worksheet.