I need an excel macro which can re-form my data in rows.
For example, I have 1000 rows of data, Every 3 or 4 or 5 lines is a record. Every record starts with "ABC". So ideally i want each record to be in a single row. As each record starts with "ABC", using "ABC" as a medium, can we get the desired result?


Submitted via EggHeadCafe - Software Developer Portal of Choice
Encryption On Mobile Devices in C# / .NET
http://www.eggheadcafe.com/tutorials...bile-devi.aspx