Branch stock convert from Vertical to Horizontal

[makinmomb]

The yellow highlights are the ware house numbers ,
That is raw data on sheet1


But the arrangement of stock is vertically , i want
the macro to convert them to horizontal , see sheet
2 expected results manually plugged

The codes and description I will run manually to find unique

The only automation required is the pull of qty from sheet1
to sheet2 to the respected warehouses

Should work on 10,000 rows of stock lines

[makinmomb]

I can also do the following by formula on D2 , that is warehouse no 2

Please Login or Register  to view this content.

But I have to struggle on the 6 different data range and do it 6 times for 6 warehouses

[nilem]

Hi makinmomb,
try this

Please Login or Register  to view this content.

[makinmomb]

Works exact only that it has pushed code 100.000.02 to the very end
instead of putting it at after 100.000.01

Good enough to close this thread , I can replace the blank cells by 0 ,
if it did that it would be cooler

[makinmomb]

Wow I must nilem , thank you too ,

It will do 10,000 rows at flash click

[Vikas_Gautam]

here is the solution ( just an addition to the nilem fantastic code )

Please Login or Register  to view this content.

[Vikas_Gautam]

here is the alternative code:

Please Login or Register  to view this content.

Check the attached file

[makinmomb]

Yes Vikas thank you for the touch tuning ,
I added some data and works super for added

warehouse 5
warehouse 6

[Vikas_Gautam]

Thanks for the feedback....