Create vertical list from non uniform horizontal list

Hi

I have a grid where a user can select different options for the length of different types of cable. From this i need to tally up the different lengths of each type of cable and create a vertical shopping list.

So for instance the image below would create a list based on the length in row 5 then the type of cable which is in cell N3, X3, AH3 and so on and finally the tallied number. So for instance:

Col A Col B Col C
(Qty) (Length) (Type)

2 25m Motor Cable 3kW EU
9 30m Motor Cable 3kW EU
1 35m Motor Cable 3kW EU
1 30m Motor Cable 11kW EU

Capture.PNG

is there a way of doing this through formulae baring in mind that the number of columns showing each cable length may change and the row the list is on might change. I have already started the tally up bit by putting a totals row on the row above the shopping list if that helps (ie shopping list is A96, B96 and C96 so I have totals on row 95

It would help if you attached a sample Excel workbook, rather than a picture of one.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post. Don't try to use the Paperclip icon, as it doesn't work on this forum.

Hope this helps.

Pete

Sorry Pete, here you go

I got rid of a few lines to reduce the amount of scrolling and how I'm currently doing this list which is not very neat as an example

Cheers