How do I organise it so that it's horizontal?

Welcome to the forum!

First of all, in your user profile, please show the Office version you have in a more recognisable format (e.g. Office 2010, Office 2013, Office 365).

Will you please attach a sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired results are also shown (mock up the results manually).

3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

4. Try to avoid using merged cells as they cause lots of problems.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.

This can be done with Power Query (Get & Transform on the Data ribbon). Here's the M code:

Please Login or Register  to view this content.

I'm attaching an example workbook. If you need help with Power Query (if you haven't used it before), just say.

Before I do, have a look at the attachment and confirm it's what you want.

It is indeed what I needed.
However it does look a little bit like chinese to me.

Edit: the code i mean

It will do if you haven't used it before! OK, it will take me a little while to prepare a step-by-step for you, so please be patient. I will post back here as soon as I can - may take about half an hour to do this in the detail you will need.

It's quite a lot of steps, but once done, you only have to refresh the query. I have written the instructions in the attachment as I have included some screenshots. By following these step-by-step instructions, you are effectively creating that M code I posted above. Let us know how you get on!

Having spent some considerable time helping you, I had rather hoped for some fairly swift feedback to say how you had got on with my instructions. As far as I can see, you have not even looked at them yet. I hope I wasn't wasting my time.

Not in PQ, but in the workbook itself, click the downward arrow on the Total column - sort Z to A.

If you want PQ to do it, add these steps to the query:

1. Select all columns except Character, and on the Home ribbon, change Data Type to Whole Numbers using the drop-down selector.
2. Now select just the Total column and use its drop-down selector to Sort Descending.

Now close and load the query to see the changes.

Originally Posted by Nub

My appoligies for the slow reply.
I have in fact looked at it straight away and was following it step by step.
But once more, I'm very sorry for my rudeness.

No rudeness - and I am sorry that I misjudged your going offline!!!

Updated workbook attached with updated query.

It looks to me as if you have missed a step or got a step wrong. Please attach your workbook for me to see.

Please update your user profile location to Belgium. I will have a look at your workbook.

Your workbook is not editable - I cannot remove whatever protection you have put on it. Please remove that and post it again.

OK - I have now managed to open it. Please go back and start again!

You MUST follow the steps in the order I have told you, otherwise you are going to get errors. You have got at least one step in the wrong place!!!

In the attached I have reordered the steps for you. I have also added a step to replace commas with decimal points before changing the data type to whole numbers. It seems to work.

That's very kind of you.

Please do practise with PQ: I have shown you some useful tricks here. I have been using PQ for about 18 months and I find it extremely useful indeed, in fact I now use it almost every day.

Don't forget to mark the thread as solved.