Bring value (variable position) from rows to column

[Dampa88]

Hi all,

I'm stacked with a formula in Excel or a way to get things sorted.

Basically, I have some rows that need to be moved into columns an repeated x-times.

Do you have any idea how can I obtain this?

Thanks for your help.

Daniele

 

[Dampa88]

Hi Joe,

It worked as expected! I really thank you for the help.

I couldn't imagine that it was possible to obtain that result with just few lines of code, I still need to learn a lot of VBA

Thanks again!

Daniele

 

[Joe4]

You are welcome!

Yes, I just programmed it to do the following:
- Insert a blank column at column A
- Loop through all the rows from the data; if column C equals "Zone", capture the zone value and delete the row, otherwise, place the last captured "Zone" value in column A

So, once you identify the pattern, you can come up with the methodology and code to do it.

There are probably other ways to do it, maybe even some more efficient that don't use loops (there often are many ways to accomplish the same task). But this one seems to work!

 

[Dampa88]

Hi Joe,

Thanks for the explanation.
I can confirm you that it works very well without slowing down the execution of the whole macro.

KR,
Daniele