+ Reply to Thread
Results 1 to 4 of 4

Need some formula to reformat data into format I want

  1. 01-19-2016, 07:22 AM #1
    rodeam
    rodeam is offline
    Registered User
    Join Date
    01-17-2016
    Location
    London, England
    MS-Off Ver
    2013
    Posts
    25

    Need some formula to reformat data into format I want

    Excel Help.xlsx

    Hey,

    Could anyone help me with some formulas do put the tables into the format I'm hoping for? I've attached an example of the tables (there are actually 700 of them) and an example of what I'm hoping for.

    Thanks in advance!

    Rodeam
    Reply With QuoteRegister To Reply
  2. 01-19-2016, 02:50 PM #2
    Greg M
    Greg M is offline
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,481

    Re: Need some formula to reformat data into format I want

    Hi there,

    Take a look at the attached workbook and see if it does what you need.

    Hope this helps - please let me know how you get on.

    Regards,

    Greg M
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 01-20-2016, 08:59 AM #3
    rodeam
    rodeam is offline
    Registered User
    Join Date
    01-17-2016
    Location
    London, England
    MS-Off Ver
    2013
    Posts
    25

    Re: Need some formula to reformat data into format I want

    Thanks! Nice macro, that worked perfectly!!
    Reply With QuoteRegister To Reply
  4. 01-20-2016, 09:43 AM #4
    Greg M
    Greg M is offline
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,481

    Re: Need some formula to reformat data into format I want

    Hi again,

    Many thanks for your feedback and also for the Reputation increase - much appreciated

    Glad I was able to help.

    Best regards,

    Greg M
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. Reformat pasted data to number format
    By pvp in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-15-2015, 10:29 AM
  2. Macro to reformat data in horizontal format to a proper Data table
    By dkrishman in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-19-2015, 10:37 AM
  3. Reformat spreadsheet data into a database format that can be Pivoted
    By dkrishman in forum Excel General
    Replies: 2
    Last Post: 03-11-2015, 10:08 PM
  4. Macro to reformat data in horizontal format to a proper Data table
    By hkaushal in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-29-2013, 08:47 PM
  5. Quick Macro to Reformat Data into specific format
    By Seraph122 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-23-2012, 07:13 AM
  6. Formula or VBA code to reformat data
    By bbook in forum Excel General
    Replies: 2
    Last Post: 01-10-2008, 11:54 AM
  7. Reformat data to vertical format
    By Psydwaze in forum Excel General
    Replies: 1
    Last Post: 06-16-2005, 01: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