Transposing Row Variables into Columns - part #2

**BHammy** · 09-26-2013, 04:30 PM

I had an earlier thread on this topic -- thank you to AB33 for the help with that one! Here, the format is slightly different -- my existing macro just needs to be altered a little bit and I tried to do it on my own but something didn't compute just right. In the attached file, I have 19 columns of data per employee vacancy. There is also room for data for up to five vacancies. The problem is that vacancy #2-5 I want stacked underneath #1 so all the data is in Columns A through S, and nothing is in Columns T through CQ.

So ideally in this attached file, "buyer" would be moved from T2 to A3, and "tax dude" would be moved downward from A3 to A4 to make room for it. "Analyst" would be underneath "tax dude," etc.

Below is the macro I have, which is not perfect but needs some tweaks:

Please Login or Register  to view this content.

Thanks for any help that anyone can offer!

**AB33** · 09-27-2013, 10:52 AM

Bhammy,
The code does as you want it. The buyer is stack underneath row 1. The reason the buyer goes to row 4 is that you have empty columns as the code loops to the last column steeping at 19.
I have changed the code to loop twice but hard coded the last column to 38.
I am not sure this what you want. Please attach your desired result. I will adjust it provided the site does not go on siesta mode.

**BHammy** · 09-27-2013, 11:32 AM

Thank you -- this created what I was looking for with putting it all into columns. This will make it a lot easier to do my analysis on these vacancies!