Formula for making a list from data base

[nelliev8]

I am sure this is a simple formula but cant get my head around it. I have a spreadsheet that I use to quote kitchens so have a list of items (a) then a column for prices (b), column where i put amount of items (c) then a total column (d). All I want to do is to make another list from this spread sheet showing all the items that have an amount against them so the employees know what items have been ordered (there will be blank columns) ie any amount in column (d )(doesnt matter amount only want the item description) would then look over at the item in column (a) and put this on a list but dont want blank spaces on new list
Hope someone can help

[shg]

Welcome to the forum.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.

[NBVC]

in a new column, say column E, row 2, enter formula:

=IF(isnumber(D2),count(E$2:E2)+1,"") and copy down

Then in another cell in a new column, Say F2, enter =MAX(E:E)

Then to get your list enter formula:

and copy down the same number of rows as your database holds, and over to next 3 columns.