Results 1 to 4 of 4

Thread: Converge Data From Multiple Columns To Single Column

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 12-14-2012, 01:29 PM #1
    ayazgreat
    ayazgreat is offline
    Member ayazgreat's Avatar
    Join Date
    Mar 2012
    Posts
    86
    Rep Power
    13

    Converge Data From Multiple Columns To Single Column

    hi

    I want to copy data (from col a to onwards) from sheet1 to sheet2 (converting in only 3 cols) ignoring cells having blank or 0 value. I am attachig here an example workbook.

    Thanks in advance.
    Attached Files Attached Files
    Somthing is better than nothing
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Sum Of A Row of Cells In Multiple Columns Based On Criteria And Column Index
    By excel_learner in forum Excel Help
    Replies: 3
    Last Post: 05-23-2013, 11:17 PM
  2. Consolidate Import Data From Same Sheet In Multiple Workbooks In To Single Workbook
    By Jorrg1 in forum Excel Help
    Replies: 1
    Last Post: 05-09-2013, 08:56 AM
  3. Lookup Data From Multiple Sheets To Single Sheet Consolidated View Using Formula
    By Redwhite in forum Excel Help
    Replies: 2
    Last Post: 03-21-2013, 10:38 PM
  4. Best way to cross populate multiple arrays based on data entry into a single array?
    By Orestees in forum Excel Help
    Replies: 14
    Last Post: 01-26-2013, 04:58 AM
  5. Transpose Multiple columns data into multiple rows
    By manoj in forum Excel Help
    Replies: 2
    Last Post: 06-14-2012, 04:10 AM

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