Posts by pmugagga

Re: data formating

Hey simon,
thanks for your input...however, what it does is list and duplicate data in columns E to H where data in H is not 0
i would like those entries to appear below the corresponding A to D entries.

thanks

sample data

[TABLE="width: 64"]

[tr]

[td]

1

[/td]

[/tr]

[tr]

[td][/td]

[/tr]

[tr]

[td]

2

[/td]

[/tr]

[tr]

[td][/td]

[/tr]

[tr]

[td][/td]

[/tr]

[tr]

[td][/td]

[/tr]

[tr]

[td][/td]

[/tr]

[tr]

[td]

3

[/td]

[/tr]

[tr]

[td]

4

[/td]

[/tr]

[tr]

[td][/td]

[/tr]

[tr]

[td][/td]

[/tr]

[tr]

[td]

5

[/td]

[/tr]

[tr]

[td][/td]

[/tr]

[tr]

[td][/td]

[/tr]

[tr]

[td][/td]

[/tr]

[tr]

[td][/td]

[/tr]

[tr]

[td][/td]

[/tr]

[tr]

[td]

6

[/td]

[/tr]

[tr]

[td]

7

[/td]

[/tr]

[/TABLE]

desired outcome

[TABLE="width: 64"]

[tr]

[td]

1

[/td]

[/tr]

[tr]

[td]

1

[/td]

[/tr]

[tr]

[td]

2

[/td]

[/tr]

[tr]

[td]

2

[/td]

[/tr]

[tr]

[td]

2

[/td]

[/tr]

[tr]

[td]

2

[/td]

[/tr]

[tr]

[td]

2

[/td]

[/tr]

[tr]

[td]

3

[/td]

[/tr]

[tr]

[td]

4

[/td]

[/tr]

[tr]

[td]

4

[/td]

[/tr]

[tr]

[td]

4

[/td]

[/tr]

[tr]

[td]

5

[/td]

[/tr]

[tr]

[td]

5

[/td]

[/tr]

[tr]

[td]

5

[/td]

[/tr]

[tr]

[td]

5

[/td]

[/tr]

[tr]

[td]

5

[/td]

[/tr]

[tr]

[td]

5

[/td]

[/tr]

[tr]

[td]

6

[/td]

[/tr]

[tr]

[td]

7

[/td]

[/tr]

[/TABLE]

I have columns A to H
If column H for any row is greater than 0, i want data from column D till H for that row to be inserted below the row

e.g.

Sample data:
[TABLE="width: 512"]

[tr]

[td]

A

[/td]

[td]

1

[/td]

[td]

2

[/td]

[td]

3

[/td]

[td]

A

[/td]

[td]

1

[/td]

[td]

2

[/td]

[td]

0

[/td]

[/tr]

[tr]

[td]

B

[/td]

[td]

1

[/td]

[td]

2

[/td]

[td]

4

[/td]

[td]

B

[/td]

[td]

2

[/td]

[td]

2

[/td]

[td]

3

[/td]

[/tr]

[tr]

[td]

C

[/td]

[td]

1

[/td]

[td]

2

[/td]

[td]

3

[/td]

[td]

C

[/td]

[td]

2

[/td]

[td]

2

[/td]

[td]

6

[/td]

[/tr]

[tr]

[td]

D

[/td]

[td]

1

[/td]

[td]

2

[/td]

[td]

7

[/td]

[td]

D

[/td]

[td]

1

[/td]

[td]

2

[/td]

[td]

0

[/td]

[/tr]

[/TABLE]

desired output:
[TABLE="width: 512"]

[tr]

[td]

A

[/td]

[td]

1

[/td]

[td]

2

[/td]

[td]

3

[/td]

[/tr]

[tr]

[td]

B

[/td]

[td]

1

[/td]

[td]

2

[/td]

[td]

4

[/td]

[/tr]

[tr]

[td]

B

[/td]

[td]

1

[/td]

[td]

2

[/td]

[td]

3

[/td]

[/tr]

[tr]

[td]

C

[/td]

[td]

1

[/td]

[td]

2

[/td]

[td]

3

[/td]

[/tr]

[tr]

[td]

C

[/td]

[td]

2

[/td]

[td]

2

[/td]

[td]

6

[/td]

[/tr]

[tr]

[td]

D

[/td]

[td]

1

[/td]

[td]

2

[/td]

[td]

7

[/td]

[/tr]

[/TABLE]