Macro
 

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

Macro
 

When you say every 3, 4, 5 lines.......ABC...etc do you mean that the
record starts with ABCxxxx and then next 3, 4, 5 lines are the rest of
the data associated with that record name?

Rahul S;578811 Wrote:
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
'.NET Compact Framework Encryption And File Transmittal With Mobile
Devices By Robbe Morris' (http://tinyurl.com/yd5rosw)


--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=160015

Microsoft Office Help

Macro
 

Excel 2007 Tables
Consolidate and transpose.
Just formulas.
http://www.mediafire.com/file/wygjmtwmxmj/07_28_09.xlsx