copy data from another worksheet but change the direction it is displayed

[dawondr]

Please see my attachment for a better understanding. On the attached I have 2 sheets, the first I call story and the 2nd is data. On the data tab I have the names of fruit and if I enter a quantity next to certain ones they will list on the story tab. The problem is I can only get them to list as a run on apples oranges grapes. What I would really like is for it to be
Apples
Oranges
Grapes

But only showing the fruit that has a value. I can get it to work just fine as a run on, but it needs to be listed down.

Not sure if u need to know how I have the data page set up (and I'm sure there are more steps than really needed but)
Column B is for the quantities
Column C is the name of the fruit
in Column E I say if there is a value in B then list B and C here.
Then in C9 i say it equals E3&E4&E5&E6&E7 this way it only shows me the fruit with a quantity selected.
Then on Story tab I tell B2 it equals C9 from the data tab.

All that works great but I just can't figure out how to make it list down instead of across

Any ideas???

Dave

PS I'm using Excel 2010

[jewelsharma]

If I understood you requirement correctly,
Change formula in Sheet "Data", cell "C9" as:

Please Login or Register  to view this content.

and allow "Wrap Text" in cell "B3" on "Story" tab. You may delete formulas in Sheet "Data" Cells "E3:E7" as we are not using them anymore.
See attached - Excel Question2.xlsx
HTH!

[dawondr]

That was exactly what I was looking for. Thank you very much!!

Dave