+ Reply to Thread
Results 1 to 3 of 3

Need to convert a chart list to a database listing.

  1. 07-24-2007, 11:46 AM #1
    sampson20 is offline
    Registered User
    Join Date
    07-24-2007
    Posts
    6

    Need to convert column data to row data.

    I am trying to convert a chart listing into a database type listing.

    Please see attachment to see a visual of my question.

    I have done something similar to this before but can't remember what I did.

    Thanks,
    Attached Images Attached Images
    Last edited by sampson20; 07-24-2007 at 03:12 PM. Reason: Add attachment
    Reply With QuoteRegister To Reply
  2. 07-25-2007, 12:33 AM #2
    rylo is offline
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591
    Hi

    How about some code.

    Assumes that your data as shown is in the range A1:D4 (including headings) and the output can go to columns F:G.

    Please Login or Register  to view this content.

    rylo
    Reply With QuoteRegister To Reply
  3. 07-25-2007, 08:48 AM #3
    sampson20 is offline
    Registered User
    Join Date
    07-24-2007
    Posts
    6

    Worked perfectly!

    Rylo,

    Thanks for the code it worked perfectly. My spreadsheet is much more elaborate but I think I understand the code you supplied well enough to expand it to meet my needs.

    I have attached a copy of my results after I added an additional column of static data to test if i could decipher the code.

    thanks again...
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1