Partial Transposing

[alperhesap]

Hi,

I want to transpose data from given table to wanted table without using macro.

In given data, Product numbers are given on the A column and each dates are on the other columns. Crossing cells contains production quantity.

How can i reach the wanted data without using macro.

Given table

Wanted table

 

[sandy666]

with Power Query aka Get&Transform
select red column then unpivot other columns, then rename if you want

• PowerQuery add-in for XL 2010/2013, All above has PQ built-in

btw. why "partial" ?