Consolidating Needing Two Columns of Information

[statboy08]

For a work project, I am trying to consolidate some materials on a spreadsheet. It has been requested of me to have both a material number and the material in two columns and then consolidate the materials. I also need to keep the material code and material in different columns.

I have tried the A1%" "B1%" code already and it was stated to me that it would be too hard to decipher.

Is there a way to consolidate this type of information or am I up a creek without a paddle?

[etaf]

Please upload a sample of your workbook to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
Would like to see an example of your data and also a manual mock up of the expected results you want to achieve.

To attach a file to your post,
click "Go advanced" (next to quick post),
scroll down until you see "manage Attachments",
click that and select "Choose File" (top Left corner).
Find your file, click "Open" click "upload" click 'close windows" Top Right. click "Submit Reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[FDibbins]

If you have a long list of duplicated materials, and want to find the total of each, 1 way would be to make a unique list of materials (if you dont already have 1) using advanced filters, then use SUMIF() for the totals.

if that was not what you wanted, then, as suggested, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.