+ Reply to Thread
Results 1 to 1 of 1

Join rows and columns for graphs

  1. #1
    Registered User
    Join Date
    01-10-2013
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    11

    Join rows and columns for graphs

    Folks, How do you join two tables between two sheets which are rows vs columns and generate a table for combination data graphs.

    Attached sheet as reference.

    Content1 sheet has multiple Methods for Topics in columns
    Content2 sheet has Methods and sub-methods in rows

    So, I tried to create a join sheet before coming up with a centralized data sheet for all combinatoric graphs.

    I have tried various ways and now using BI to join the sheets by re-doing the data and this certainly is not going to help in long term.

    Any help appreciated.
    Attached Files Attached Files

+ 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. [SOLVED] Transposing columns to rows: Preparing MALLET for Gephi (topic modeling + network graphs)
    By kioken in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-11-2017, 02:07 AM
  2. Join two tables with same columns?
    By blokeyhighlander in forum Excel General
    Replies: 2
    Last Post: 01-13-2015, 12:10 PM
  3. SQL - Join two columns into one
    By kenny.fsw in forum Access Tables & Databases
    Replies: 4
    Last Post: 08-02-2012, 04:03 AM
  4. Join columns
    By MFT in forum Excel General
    Replies: 4
    Last Post: 04-27-2010, 10:02 AM
  5. join two columns....
    By visitnag in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-17-2008, 01:25 PM
  6. [SOLVED] How do I join graphs together in Excel?
    By Clare in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-10-2005, 08:45 PM
  7. join columns, keep both values
    By FourPenny in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 05-30-2005, 08:36 PM

Tags for this Thread

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