# Sorting data by currency

1. ## Sorting data by currency

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!

2. ## Re: Sorting data by currency

There are instructions at the top of the page explaining how to attach your sample workbook.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.

Members will tailor the solutions they offer to the version (NOT release number) of Office (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this. Thanks.

3. ## Re: Sorting data by currency

Apologies, this should be uploaded now! tab1 is the original data, 2 is how I want it to display, and 3 is pivot table. I just don't know the next steps? Thanks!

4. ## Re: Sorting data by currency

Formula:
`Please Login or Register  to view this content.`

5. ## Re: Sorting data by currency

You're a genius, thank you! If you have a moment (or 2!) and could explain this please, that would be amazing. I have had a google but if you could relay the explanation in the context of my example that would be great. But thank you, as this works so just need to apply to the real data.

6. ## Re: Sorting data by currency

Power Query
``Please Login or Register  to view this content.``

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1