database format

  1. K

    Database help please - multiple rows with same data in many columns

    I am trying to build a database for my customers, where I can sort by very detailed info. I might have a customer (name - contact - address) all identical, entered 20 times, with one column (product) different in each row. I need to be able to sort the database by product - so as far as I can...
  2. M

    Mutiple values return with data validation

    Hi all: I need some help here. First time poster.. I need help with my dropdown lists, returning multiple values attached to each entry. If I fill down my formulas it only returns one value; not the list attached. Please PM me if you know an easy fix. Thanks ! :confused:
  3. B

    Issue with Database Clean Up. Split info into 2 cells but issue with data is 1string. Thanks!

    Hello, this is my first post so please inform me if I am doing anything wrong or there something I can clarify. I am working on a project and have ran into an problem with separating lines of data. So let me first show what I am doing because I wont want to take an unnecessary block of your...
  4. R

    How do I convert an Excel data table into database format?

    in a simple example I want to convert a table like: SKU DESC Jan-12 Feb-12 Mar-12 123 prod1 10 42 34 345 prod2 90 10 39 Into database format like below, so that I can do data analysis with pivot table. SKU DESC MONTH QTY 123 prod1...

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
Back
Top