Results 1 to 8 of 8

How to change colums to values

Threaded View

  1. #1
    Registered User
    Join Date
    06-14-2014
    Posts
    4

    How to change colums to values

    Not sure if the title represents the question I am asking but here is the challenge. I have a spreadsheet with has the value "Name" and each month as the column header. In each row it will have the persons name and under each month header it will have their sales amount. I have included an example in this thread.



    My goal is to upload this spreadsheet into access with the columns name, month and sales amount so I can use this temporarily to compare with other tables.



    The first tab shows how the current data is formatted. The second tab show how I would like to possibly store it in access.


    Prepping data is not my strong point, so feel free to give me other ideas. Once I get it into access, I can write sql all day. Can I get some ideas on how to go from tab1 to tab2?



    Thanks!

    CoachJohn
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Compare values in two colums
    By p3x935 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-30-2014, 12:32 PM
  2. change rows to colums
    By Jerry.Peoples in forum Excel General
    Replies: 4
    Last Post: 03-16-2010, 11:16 AM
  3. Merge Sheets into one, and change rows to colums
    By MSTARS in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-21-2009, 05:11 PM
  4. [SOLVED] how can i change my sprdsht to list info from colums into rows
    By kate in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-18-2006, 11:00 AM
  5. Change colour of bars/lines in charts when data in rows/colums
    By RodP in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-27-2005, 01:05 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