Search a range, move data in pairs to a single column

Hello forumers,

I was wondering if anything can help me with a script to accomplish the following. I have a data set with the following: columns A through G are static data, as well as column R through U. The range I am working with is columns H through Q. Essentially, i want to search my range and move any data that is not already in column H or I. Then copy the static data that support it. I guess this is called transposing...from rows into a column. Hopefully my before.xls and after.xls examples illustrate my goal.

Thank you for taking the time to look and offer help,

wherbjr35

try this:

Please Login or Register  to view this content.

This code assumes a few things: 1) All periods are filled in at the time you want to transpose the data for a particular row 2) You insert a column for showing the period 1 through 5 just to the left of the column you call Q1 and 3) you remove extra columns no longer used.

Please Login or Register  to view this content.

I've attached my example as well.
Good luck!

-Greg