Hello,
I am looking for macro which is able to exchange levels I have in BOM (downloaded to excel). Do you know easy way how to do it?
Oryginaly I have:
I need:
I am looking for macro which is able to exchange levels I have in BOM (downloaded to excel). Do you know easy way how to do it?
Oryginaly I have:
Code:
[TABLE="width: 119"]
<tbody>[TR]
[TD].1[/TD]
[/TR]
[TR]
[TD]..2[/TD]
[/TR]
[TR]
[TD]...3[/TD]
[/TR]
[TR]
[TD]....4[/TD]
[/TR]
[TR]
[TD]....4[/TD]
[/TR]
[TR]
[TD].....5[/TD]
[/TR]
[TR]
[TD]....4[/TD]
[/TR]
[TR]
[TD]...3[/TD]
[/TR]
[TR]
[TD]....4[/TD]
[/TR]
[TR]
[TD]...3[/TD]
[/TR]
[TR]
[TD]...3[/TD]
[/TR]
[TR]
[TD]..2[/TD]
[/TR]
[TR]
[TD]..2[/TD]
[/TR]
[TR]
[TD].1[/TD]
[/TR]
[TR]
[TD]..2[/TD]
[/TR]
[TR]
[TD]...3[/TD]
[/TR]
[TR]
[TD]..2[/TD]
[/TR]
[TR]
[TD]...3[/TD]
[/TR]
[TR]
[TD]..2[/TD]
[/TR]
[TR]
[TD]...3[/TD]
[/TR]
[TR]
[TD]....4[/TD]
[/TR]
[TR]
[TD]..2[/TD]
[/TR]
[TR]
[TD]...3[/TD]
[/TR]
[TR]
[TD]..2[/TD]
[/TR]
[TR]
[TD]...3[/TD]
[/TR]
[TR]
[TD]..2[/TD]
[/TR]
[TR]
[TD]...3[/TD]
[/TR]
[TR]
[TD]..2[/TD]
[/TR]
[TR]
[TD]...3[/TD]
[/TR]
[TR]
[TD]..2[/TD]
[/TR]
[TR]
[TD]...3[/TD]
[/TR]
[TR]
[TD]..2[/TD]
[/TR]
[TR]
[TD]...3[/TD]
[/TR]
[TR]
[TD]..2[/TD]
[/TR]
[TR]
[TD]..2[/TD]
[/TR]
[TR]
[TD]...3[/TD]
[/TR]
[TR]
[TD]..2[/TD]
[/TR]
[TR]
[TD]...3[/TD]
[/TR]
[TR]
[TD]..2[/TD]
[/TR]
[TR]
[TD]...3[/TD]
[/TR]
[TR]
[TD]..2[/TD]
[/TR]
[TR]
[TD]...3[/TD]
[/TR]
[TR]
[TD]..2[/TD]
[/TR]
[TR]
[TD]..2[/TD]
[/TR]
[TR]
[TD]..2[/TD]
[/TR]
[TR]
[TD]...3[/TD]
[/TR]
[TR]
[TD]...3[/TD]
[/TR]
[TR]
[TD]...3[/TD]
[/TR]
[TR]
[TD]...3[/TD]
[/TR]
[TR]
[TD]....4[/TD]
[/TR]
[TR]
[TD].....5[/TD]
[/TR]
[TR]
[TD]...3[/TD]
[/TR]
[TR]
[TD].1[/TD]
[/TR]
[TR]
[TD].1[/TD]
[/TR]
[TR]
[TD]..2[/TD]
[/TR]
[TR]
[TD]..2[/TD]
[/TR]
[TR]
[TD].1[/TD]
[/TR]
[TR]
[TD].1[/TD]
[/TR]
[TR]
[TD].1[/TD]
[/TR]
[TR]
[TD].1[/TD]
[/TR]
[TR]
[TD].1[/TD]
[/TR]
[TR]
[TD].1[/TD]
[/TR]
[TR]
[TD].1[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
I need:
Code:
[TABLE="width: 54"]
<tbody>[TR]
[TD]1
[/TD]
[/TR]
[TR]
[TD]1.1
[/TD]
[/TR]
[TR]
[TD]1.1.1
[/TD]
[/TR]
[TR]
[TD]1.1.1.1
[/TD]
[/TR]
[TR]
[TD]1.1.1.2
[/TD]
[/TR]
[TR]
[TD]1.1.1.3
[/TD]
[/TR]
[TR]
[TD]1.1.2
[/TD]
[/TR]
[TR]
[TD]1.1.3
[/TD]
[/TR]
[TR]
[TD]1.1.4
[/TD]
[/TR]
[TR]
[TD]1.2
[/TD]
[/TR]
[TR]
[TD]1.3
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[/TR]
[TR]
[TD]2.1
[/TD]
[/TR]
[TR]
[TD]2.1.1
[/TD]
[/TR]
[TR]
[TD]2.2
[/TD]
[/TR]
[TR]
[TD]2.2.1
[/TD]
[/TR]
[TR]
[TD]2.3
[/TD]
[/TR]
[TR]
[TD]2.3.1
[/TD]
[/TR]
[TR]
[TD]2.4
[/TD]
[/TR]
[TR]
[TD]2.4.1
[/TD]
[/TR]
[TR]
[TD]2.5
[/TD]
[/TR]
[TR]
[TD]2.5.1
[/TD]
[/TR]
[TR]
[TD]2.6
[/TD]
[/TR]
[TR]
[TD]2.6.1
[/TD]
[/TR]
[TR]
[TD]2.7
[/TD]
[/TR]
[TR]
[TD]2.7.1
[/TD]
[/TR]
[TR]
[TD]2.8
[/TD]
[/TR]
[TR]
[TD]2.8.1
[/TD]
[/TR]
[TR]
[TD]2.9
[/TD]
[/TR]
[TR]
[TD]2.9.1
[/TD]
[/TR]
[TR]
[TD]2.10
[/TD]
[/TR]
[TR]
[TD]2.11
[/TD]
[/TR]
[TR]
[TD]2.12
[/TD]
[/TR]
[TR]
[TD]2.13
[/TD]
[/TR]
[TR]
[TD]2.14
[/TD]
[/TR]
[TR]
[TD]2.15
[/TD]
[/TR]
[TR]
[TD]2.16
[/TD]
[/TR]
[TR]
[TD]2.17
[/TD]
[/TR]
[TR]
[TD]2.17.1
[/TD]
[/TR]
[TR]
[TD]2.17.1.1
[/TD]
[/TR]
[TR]
[TD]2.17.2
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[/TR]
[TR]
[TD]4.1
[/TD]
[/TR]
[TR]
[TD]4.2
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[/TR]
[TR]
[TD]6
[/TD]
[/TR]
[TR]
[TD]7
[/TD]
[/TR]
[TR]
[TD]8
[/TD]
[/TR]
[TR]
[TD]9
[/TD]
[/TR]
[TR]
[TD]10
[/TD]
[/TR]
[TR]
[TD]11
[/TD]
[/TR]
</tbody>[/TABLE]
Last edited: