+ Reply to Thread
Results 1 to 3 of 3

Transpose values from column to rows (one cell) with conditions

  1. #1
    Registered User
    Join Date
    08-13-2012
    Location
    Slovenia
    MS-Off Ver
    Excel 2010
    Posts
    72

    Transpose values from column to rows (one cell) with conditions

    Hello to all
    I need formula or something else (mybe not a macro don't like it very much)
    colum A and B are data. C is calculation column. in cell in column C i want all data of B for all rows in column A for same number.
    In column A where is blank cell, there is a same number like in upper row

    Hope understand! Thanks for help !

    Please see attach!
    Attached Files Attached Files
    Last edited by zeko90; 09-06-2013 at 07:43 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    09-04-2012
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    463

    Re: Transpose values from column to rows (one cell) with conditions

    i think you should upload one excel file in which you should have two sheets

    on sheet1 you should enter you sample problem data

    and on sheet2 you should provide us manual expected output.

    So that we can provide you a best and short formula.

    Regards
    CA Mahaveer Somani

  3. #3
    Valued Forum Contributor
    Join Date
    09-15-2011
    Location
    Chennai, India
    MS-Off Ver
    Excel 2010
    Posts
    436

    Re: Transpose values from column to rows (one cell) with conditions

    I have maximum tried with Excel functions.

    Note: The VBA part alone is copied from other source. (Concatenate mechanism)
    Attached Files Attached Files
    Last edited by ramananhrm; 09-06-2013 at 08:23 AM.
    Please click 'Add reputation', if my answer helped you.

+ 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. Transpose every 5 cells in column A to indidual rows in column B
    By meridklt in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-14-2013, 12:35 AM
  2. Insert rows, transpose data from column in to rows, in steps
    By mchevalier in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-01-2012, 08:14 PM
  3. Transpose Column to Rows
    By hardeep.kanwar in forum Excel General
    Replies: 7
    Last Post: 03-29-2010, 05:57 AM
  4. Trying to transpose values from various rows to a cell
    By nhsyd in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-10-2010, 07:07 PM
  5. [SOLVED] Transpose unique values in one column/mult. rows into a single row
    By Wil in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-22-2005, 04:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1