+ Reply to Thread
Results 1 to 2 of 2

Place all COLUMNS and place them in 1 Summary sheet SIDE-BY-SIDE

  1. 04-06-2017, 08:34 AM #1
    countryfan_nt
    countryfan_nt is offline
    Forum Contributor
    Join Date
    06-24-2004
    MS-Off Ver
    Excel 2013 Pro Plus
    Posts
    122

    Place all COLUMNS and place them in 1 Summary sheet SIDE-BY-SIDE

    Hello friends, hope all is well!

    Please help with the best solution and steps please.

    The attachment here has sheets: 1, 2, 3 and or more.

    • Column A in each sheet is the same.
    • I want to paste all the columns of each sheet in the summary sheet, side by side.
    • Summary sheet should show the desired results.

    What is the fastest way? Power-Query? VB, etc… and how?

    Thank you so much in advance!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-06-2017, 09:27 AM #2
    mike7952
    mike7952 is offline
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,551

    Re: Place all COLUMNS and place them in 1 Summary sheet SIDE-BY-SIDE

    This will work

    Please Login or Register  to view this content.
    Last edited by mike7952; 04-06-2017 at 09:29 AM.
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    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)

Similar Threads

  1. [SOLVED] how to place two x axis items side by side for one item being described
    By Emma Eve in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 04-21-2015, 12:29 PM
  2. [SOLVED] Need to vertically combine multiple side-by-side columns
    By alillian in forum Excel General
    Replies: 13
    Last Post: 10-22-2014, 05:33 PM
  3. VBA to copy data from multiple sheets side-by-side into one sheet matching date
    By MHCapcog in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 04-02-2013, 06:11 PM
  4. [SOLVED] Place an ! either side of all data
    By djfscouse in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-16-2013, 06:31 AM
  5. Help with moving columns from multiple worksheets into one worksheet side by side
    By gary619 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-16-2012, 04:54 PM
  6. [SOLVED] Display columns side by Side in the Data Area of a Pivot table
    By Sue in forum Excel General
    Replies: 1
    Last Post: 03-20-2006, 10:15 PM
  7. [SOLVED] How do I create stacked columns in xcel rather than side-by-side
    By Gin from Boeing in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-21-2005, 12:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1