Taking data in rows and stacking into columns

Hi,

I'm a new member to the forum and hoping someone may be able to help me out with this question.

I have a workbook that compiles data by Employee ID in a row format, meaning that all data for that employee is in one, single row. However, to upload this data into another system I have to stack some data into multiple rows, then move the next employee and so on.

To get a better understanding, please take a look at the attached file. I have one tab that shows how the data is originally compiled, then the 2nd tab shows how the import file should look. I would like to have excel take the 1 row of original data and stack it into the 3 rows needed for the import.

Please post any questions and I'll answer as soon as possible. Thanks to everyone in the group for your assistance.

Arlu,

Thanks for the code, however I cannot get it to work. When I run the Macro Excel locks up and I have force close the program to continue. Any ideas?

Jcoe,

I would suggest going into the VBA editor and by using F8 going through the process step by step to find the part of the code that breaks your computer.

Hi Arlu,

For some reason

Please Login or Register  to view this content.

Doesn't work for me.

This addition would seem to fix that problem on Excel 2010:

Please Login or Register  to view this content.