+ Reply to Thread
Results 1 to 4 of 4

Any Suggestions on Formatting a List into a Usable Data Set/Table/Database?

  1. #1
    Registered User
    Join Date
    06-13-2012
    Location
    USA
    MS-Off Ver
    Excel 2013
    Posts
    63

    Any Suggestions on Formatting a List into a Usable Data Set/Table/Database?

    Good morning! I have a list of information that I need to be able to build sumifs and lookups/matches on, and it would be extremely beneficial if I could format it in a table (like pictured).

    I cannot just copy and paste/transpose each piece of information because there are thousands.

    Just throwing it out there to see if someone else is a little more creative than me... I've been staring at it too long for now.

    Thanks in advance!




    j7Y8K99.png

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,038

    Re: Any Suggestions on Formatting a List into a Usable Data Set/Table/Database?

    Here's one solution but I'm pretty sure it aint gonna work.
    You could match the "Brand" in column A with column D so you pull across the right data.
    But I;m pretty sure your data doesn't look like

    Fred's Store
    Fred's location
    ...
    ...
    ...
    Bert's Store
    Bert's Location
    ...
    ...

    So what's your actual data look like? Make it up if it's sensitive.

    Does EVERY entry have 9 lines then a blank?
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often 365, but still time to time use also older versions
    Posts
    8,147

    Re: Any Suggestions on Formatting a List into a Usable Data Set/Table/Database?

    if it is regular (each store has the same number of rows for description it would be pretty easy with formulas Using OFFSET (or INDIRECT if you prefer) and ROW
    for instance simple one in D4:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    and copy down, E5:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    etc.
    Best Regards,

    Kaper

  4. #4
    Registered User
    Join Date
    06-13-2012
    Location
    USA
    MS-Off Ver
    Excel 2013
    Posts
    63

    Re: Any Suggestions on Formatting a List into a Usable Data Set/Table/Database?

    Quote Originally Posted by Special-K View Post
    Here's one solution but I'm pretty sure it aint gonna work.
    I'm actually just going to use a index/match combo and reference the column and row numbers to get it to work. Thank you for your help though!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 7
    Last Post: 10-20-2015, 01:51 PM
  2. Database suggestions
    By Soywheat in forum Excel General
    Replies: 1
    Last Post: 03-18-2013, 11:37 PM
  3. Pivot table - Usable notes section OR cells move with data
    By ThomasCarter in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-09-2012, 06:30 AM
  4. Match data between CSV and database and update column in database table
    By djfscouse in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-05-2012, 05:59 PM
  5. Convert Data into Usable database format
    By drbotts in forum Excel General
    Replies: 2
    Last Post: 07-02-2012, 01:31 PM
  6. Table to List Data Formatting Problem.
    By headscratching in forum Excel General
    Replies: 4
    Last Post: 12-23-2010, 07:00 AM
  7. finding and copying data to a usable table
    By Johnidge in forum Access Programming / VBA / Macros
    Replies: 2
    Last Post: 10-16-2009, 11:35 AM
  8. Trying to match a text string to a data table, any suggestions?
    By OCONUS in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-02-2005, 02:45 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1