Transpose: How can I copy a list and transpose it but leaving 3 cells in between each item

Hello,

So as the question states I have a data base with around 10k securities. I'm aplying a formula to thos securities that will add three rows to the right and multiple rows going down.

I want to take all that data copy and transposing it leaving enough space in between each security to run the formula and not have it over lap in my data.

Any insights?

Thank You

Can you show me how it looks before you "transpose" it?

This should work:

Please Login or Register  to view this content.

Since you say the nnumber of securities you need to "transpose" is over 10k, I think that at one point you will run out of columns, so when that happens the code I provide will move to the next row. You could add a multiplier to the variable n so that instead of 1 row it moves downwards more, in case you also need to leave space between lines. For example, if you change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

then you will be leaving 3 empty rows in between used rows. You can also change the 16 to whichever row you want your data to start at.