Sorting

[Daniel Louwrens]

I have Excel 2000 SP3,

I have a worksheet with recipes spread down and across three columns 600
lines long, the recipes were loaded from a Database and need to be sorted.
Column (a) shows the recipe name, column (b) shows the
ingredient, column (c) shows the quantity of each ingredient in that recipe.
Each recipes adds to 100 but there can be between two to five ingredients in
each recipe and they are not separated.
I need to
1) Separate each recipe
2) Show them across the spreadsheet not down it.

If anyone can tell me how to do this I would appreciate it.

thanks

Daniel

 

[Dave Peterson]

I think if you give more information, it'll make it easier for responders.

Column A contains the recipe name
(for each row that has an item in that recipe, or does that recipe name only
show up on the first row of that recipe?)

What does "adds to 100" mean? Does that mean each recipe has 100 rows reserved
for all the info--but doesn't always use them?

If they're not used, are both column B and C not used?

 

[Daniel Louwrens]

Yes, I though there might be a problem
with the way I have explained it.
I will try to answer your questions below.

thanks

Daniel

I think if you give more information, it'll make it easier for responders.

Column A contains the recipe name
(for each row that has an item in that recipe, or does that recipe name only
show up on the first row of that recipe?) It is for each row
What does "adds to 100" mean? Does that mean each recipe has 100 rows reserved
for all the info--but doesn't always use them?

No, it means the recipes always total 100 but may be any number of rows but
usually 3 to 5 rows. example 20 + 25 + 15 + 40

If they're not used, are both column B and C not used?

Columns a, b and c are all uses
a is the name of the product
b is the ingredient
c is the quantity of that ingrediend