Results 1 to 7 of 7

Formula help for transposing data from columns to rows

Threaded View

  1. 08-24-2015, 04:34 PM #1
    Barbara Excel
    Barbara Excel is offline
    Registered User
    Join Date
    05-15-2011
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2007, Excel MAC 2008
    Posts
    64

    Formula help for transposing data from columns to rows

    Guys

    looking for a bit of help with a formula.
    I thin it will involve offset, but coming to a dead end.

    I have attached example data.

    I require a formila that will deliver the data as below with the column headings

    Date ID Value Volume

    From my data which looks like this
    15.06.2015 22.06.2015 29.06.2015
    ABC ltd Value 150 120 80
    ABC ltd Volume 47 151
    ADE ltd Value 1240 900 1080
    Ade ltd Volume 600 2420 731

    Any help appreciated guys

    Barbara
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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] Transposing Data from rows to columns
    By Joe47 in forum Excel General
    Replies: 7
    Last Post: 07-09-2013, 05:42 AM
  2. [SOLVED] Transposing Data from Columns to Rows
    By David Hedley in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-30-2013, 05:17 AM
  3. [SOLVED] Need VBA Sub for Transposing Data in Columns to Rows
    By Phoenix1975 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-17-2013, 04:41 PM
  4. Transposing ~ 25,000 rows of data into Columns
    By strickrn in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 01-29-2013, 09:54 PM
  5. Transposing data from rows into columns (columns have been merged)
    By TommyGato in forum Excel General
    Replies: 8
    Last Post: 11-02-2011, 02:45 PM
  6. Transposing Rows to Columns and their data
    By scojo in forum Excel General
    Replies: 8
    Last Post: 11-14-2007, 05:22 PM
  7. Transposing data from columns to rows
    By Annalise Vogel in forum Excel General
    Replies: 5
    Last Post: 11-25-2005, 02:30 PM
  8. Transposing Data in rows to columns (complex)
    By Colin T in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-15-2005, 06:05 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