Macro help required

[yrajnani]

I need your help in creating a macro to automate my data entry process
Below is how my sheet appears
A1-A554 is my product list , C1:C554 is their MRP List

Column L,Q,V,AA till IM (in a GAP of 5 have Opening Stock)
Similarly Column M,R,W,AB till IN ((in a GAP of 5 have Supply Stock)
And Column N,S,ZX,AC till IO have sales Stock (in a GAP of 5 have Sales Stock)
Counter codes are mentioned in merged cells (for e.g, L2:P2 has 1 counter code), (Q2:U2 has 1 counter code)
I need to put this data for a pivot dump in such a way that
Column A - HAS ALL PRODUCTS
Column B has their prices
Column C has their sales
Column D has supply
Column E has their opening Qty and Column F has the respective counter code..

Is it possible.. Any help with this would be highly appreciated..

Thanks,
Yogita