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.