Hello to all,

May somebode help me with this please.

I have a scripting dictionary that:

- In keys contains strings with format some "Fruit" + "|" + W,X,Y or Z.

- In Items contains numbers related with each key.

[TABLE="class: grid, width: 200, align: center"]

Keys

[/td][td]Items

[/td][/tr][tr][td]Apple|W

[/td][td]4

[/td][/tr][tr][td]Pear|W

[/td][td]5

[/td][/tr][tr][td]Pear|X

[/td][td]3

[/td][/tr][tr][td]Mango|Z

[/td][td]1

[/td][/tr][tr][td]Apple|Z

[/td][td]2

[/td][/tr][tr][td]Pear|Y

[/td][td]7

[/td][/tr][tr][td]Apple|Y

[/td][td]8

[/td][/tr][tr][td]Mango|X

[/td][td]12

[/td][/tr][tr][td]Apple|X

[/td][td]6

[/td][/tr]

[/TABLE]

I would like to print in sheet1,

In column A only the fruits (appearing each fruit only once)

In column D the value associated with "W" for each fruit, this is for "Fruit|W"

In column E the value associated with "X" for each fruit, this is for "Fruit|X"

In column F the value associated with "Y" for each fruit, this is for "Fruit|Y"

In column G the value associated with "Z" for each fruit, this is for "Fruit|Z"

So, the final output would be:

[TABLE="class: grid, width: 200, align: center"]

A

[/td][td]B

[/td][td]C

[/td][td]D

[/td][td]E

[/td][td]F

[/td][td]G

[/td][/tr][tr][td]Apple

[/td][td][/td][td][/td][td]4

[/td][td]6

[/td][td]8

[/td][td]2

[/td][/tr][tr][td]Pear

[/td][td][/td][td][/td][td]5

[/td][td]3

[/td][td]7

[/td][td]0

[/td][/tr][tr][td]Mango

[/td][td][/td][td][/td][td]0

[/td][td]12

[/td][td]0

[/td][td]1

[/td][/tr]

[/TABLE]

Thanks in advance for any help.