+ Reply to Thread
Results 1 to 4 of 4

Reformatting Data

  1. 08-29-2014, 06:08 AM #1
    stephboucher
    stephboucher is offline
    Registered User
    Join Date
    01-18-2011
    Location
    Somerset
    MS-Off Ver
    Excel 2010
    Posts
    28

    Reformatting Data

    Please see attached spreadsheet - from ititial data (cells A2:D3) i need to reformat the data giving me a line per date, rather than as it is supplied, as a date range against an individual.

    Cells A12:C29 demonstrate the result I would like to achieve.

    Thanks in advance

    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-29-2014, 07:11 AM #2
    stanleydgromjr
    stanleydgromjr is offline
    Forum Expert
    Join Date
    10-10-2008
    Location
    Northeast Pennsylvania, USA
    MS-Off Ver
    Excel 2007
    Posts
    2,387

    Re: Reformatting Data

    stephboucher,

    Detach/open workbook ReorgData w1 array wr oarray - stephboucher - EF1034064 - SDG15.xlsm and run the ReorgData macro.
    Attached Files Attached Files
    Have a great day,
    Stan

    Windows 10, Excel 2007, on a PC.

    If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
    Reply With QuoteRegister To Reply
  3. 09-03-2014, 04:27 AM #3
    stephboucher
    stephboucher is offline
    Registered User
    Join Date
    01-18-2011
    Location
    Somerset
    MS-Off Ver
    Excel 2010
    Posts
    28

    Re: Reformatting Data

    Thats great - thanks very much
    Reply With QuoteRegister To Reply
  4. 09-05-2014, 01:46 PM #4
    stanleydgromjr
    stanleydgromjr is offline
    Forum Expert
    Join Date
    10-10-2008
    Location
    Northeast Pennsylvania, USA
    MS-Off Ver
    Excel 2007
    Posts
    2,387

    Re: Reformatting Data

    stephboucher,

    Thanks for the feedback.

    You are very welcome. Glad I could help.

    And, come back anytime.
    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. Reformatting Raw Data
    By stinkyd in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-15-2013, 11:28 PM
  2. Reformatting Data
    By carrielynne in forum Excel General
    Replies: 8
    Last Post: 04-04-2013, 03:36 PM
  3. Reformatting data
    By Jchhoule in forum Excel General
    Replies: 5
    Last Post: 05-22-2012, 12:22 PM
  4. Excel 2007 : Data reformatting
    By matt1234 in forum Excel General
    Replies: 1
    Last Post: 05-30-2011, 11:19 AM
  5. Reformatting data
    By gabe63 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-02-2010, 09:47 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