format data

Tpw44

New Member
Joined
Dec 13, 2020
Messages
2
Office Version
  1. 365
  2. 2011
Platform
  1. Windows
Hello

I am having a problem formatting data in excel, I am preparing this data to import into a database that i have created.
the problem is as follows:
the raw data i have is for multiple chocolate recipe's that are broken down into the following:
  • Name of recipe
  • weight of ingredients
  • unit of weight of ingredient
  • ingredient name
  • ingredient details
  • step number
  • method for each step
  • finishing ingredient
  • use for the recipe
the thing i cant figure out is how to set this data out to be imported into a database to be displayed on a form
if a recipe has 10 ingredients with 10 units of measurement, 10 quantity's for that unit of measurement, 10 methods for the recipe with 10 steps that need to be picked up in import as all corresponding to one recipe (one name of recipe) how to you split the data so the import knows the weight, unit, ingredient ect is separate but relates to just one recipe name.

im not sure if i have explained this correctly, i have attached a recipe for reference.

thankyou in advance
 

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

maabadi

Well-known Member
Joined
Oct 22, 2012
Messages
1,347
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
Welcome to MrExcel Message Board.
Please Upload Example file with XL2BB addin and show what exactly you want. or if you cannot share an image.
 

Tpw44

New Member
Joined
Dec 13, 2020
Messages
2
Office Version
  1. 365
  2. 2011
Platform
  1. Windows
Welcome to MrExcel Message Board.
Please Upload Example file with XL2BB addin and show what exactly you want. or if you cannot share an image.
Hi thanks I figured out I need to format the raw data as a bill of material in order to track the data at all implementation phases as it is split into sub-assemblies, intermediate assemblies and sun-components!
cheers
 

Watch MrExcel Video

Forum statistics

Threads
1,122,991
Messages
5,599,235
Members
414,297
Latest member
dalkarl

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top