rebuild structure

[czingishan]

Hi
I have file about this structure
-----A----B
1--test1--,
2--test2--,
3--test3--,
4--test4--,
5--test5--,
6--test6--,
(...)
(about 20 000 lines)

And I need to rebuild to this structure

-----A------B------C-----D------E-----F----(...)
1--test1----,----test2----,----test3----,----(...)---test49---,---test50---,
2--test51---,---test52----,---test53----,----(...)--test99---,---test100--,
etc.
Can you do it?

[StevenM]

Place the code below in a standard module (if you don't know how, ask)
Run: RebuildStructure

The result is in new worksheet.

Please Login or Register  to view this content.

[czingishan]

Thanks!
I have another problem
I have file about this structure
------A-----
1---test1---
2------------
3---test2---
4------------
5---test3---
etc.

And I need to rebuild to this structure
------A-----
1---test1---
2---test2---
3---test3---
etc.

[StevenM]

Backup your data.
The following code will delete rows where the cell in column A is empty.

Please Login or Register  to view this content.