Hoping someone can help. I have a list of data with the "items" in the first column, followed by a monetary value to reflect their cost in different currencies in the row cells next to the item (see pic "data")
DATA.JPG
I need to see the currencies split across rows vertically though (see pic "datanew")
So I have tried the pivot table but can't work out how to then arrange the data manually as there will need to be 3 duplicates of each item to go next to the 3 currencies:
DATANEW.JPG
I hope this is clear and apologies if I have missed something!
Thanks in advance
Bookmarks