Results 1 to 3 of 3

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

Threaded View

  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.

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. 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