Converting multiple columns into multiple rows

**papagrande3** · 08-19-2010, 05:37 PM

I apologize in advance for any incorrect use of terminology or lack of explanation... I am fairly new to all of this.

**FILE ATTACHED TO THREAD (2 TABS)**

I am needing to convert a 2 column report into a report with one horizontal heading (from Original-Column A) and their corresponding rows (Original-Column B). There is not a constant number of rows to separate them. The only way I can see to break them up is by Column A, Line Name to the Sub-Type Mod, prior to the next Line Name...

It will probably make much more sense seeing the file included...

Thanks!

**lazyme** · 08-19-2010, 06:21 PM

Will the row in Original always follow the same sequence?

**papagrande3** · 08-19-2010, 06:27 PM

Count-wise, no it doesn't. That is the main issue that I am having in formulating it. The number of rows that contain "Sub-Type Mod" following "Line Name", varies throughout all 250,000 + entries I need to do.

**papagrande3** · 08-19-2010, 06:28 PM

However, the only 2 entries for Column A will be one of those 2, "Sub-Type Mod" or "Line Name"...just not in any specific sequence

**lazyme** · 08-19-2010, 06:38 PM

Ok, not the same sequence is fine but the "Sub-Type Mod" always follow the subsequent "Line Name" correct? They won't be seperated right?

**papagrande3** · 08-19-2010, 06:39 PM

Yes, that's correct.

**lazyme** · 08-19-2010, 07:19 PM

Add a module and run the following macro.

Please Login or Register  to view this content.

**papagrande3** · 08-20-2010, 01:05 AM

lazyme,

You are absolutely amazing!!! Thank you so much! I tried it out on a small portion, containing around 3000 entries. They came out EXACTLY as I needed!! That module will be used a great deal. (~250,000 total entries) This will save me a tremendous amount of work.

I have never used Macro, so this was completely new to me...Took me a while to figure out the basics..however, it was an awesome learning experience. I will definitely be reading up on it some more and I definitely intend to use it much more often. Thanks again for everything!!!!!