Results 1 to 4 of 4

Formula for Converting data

Threaded View

  1. 06-28-2016, 05:46 AM #1
    Shanju
    Shanju is offline
    Registered User
    Join Date
    06-28-2016
    Location
    Sri Lanka
    MS-Off Ver
    2013
    Posts
    2

    Formula for Converting data

    Hi All

    Can any one give me a solution for converting a table of data in a given format.
    Since it is large data set i need a formula for converting.

    Here I have attached the excel sheet.

    Thanks..
    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. Converting Matrix Data into a 3-column format with a formula
    By alexx579 in forum Excel General
    Replies: 1
    Last Post: 03-17-2016, 05:44 PM
  2. [SOLVED] Formula to count Date without converting data to Text Format
    By syed82 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-30-2014, 12:21 AM
  3. formula for converting vertical data set into horizontal
    By bsapaka in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-01-2014, 09:29 PM
  4. Converting multiple columns to rows / Converting to Panel Data
    By Stuart11 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-14-2013, 05:50 AM
  5. Converting formula data to hard # result
    By Eagle in forum Excel General
    Replies: 4
    Last Post: 11-11-2011, 12:42 PM
  6. converting column data to row data using formula
    By murarihyd in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-22-2011, 10:11 PM
  7. Excel 2007 : Converting horizontal data to vertical data (more than just transposing)
    By glens73 in forum Excel General
    Replies: 5
    Last Post: 04-23-2010, 08:01 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


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1