+ Reply to Thread
Results 1 to 2 of 2

VBA code to convert multiple rows as column header grouped by unique key

  1. #1
    Registered User
    Join Date
    07-24-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    1

    VBA code to convert multiple rows as column header grouped by unique key

    Hi All,
    I have data in excel sheet in the below format:
    Existing view.png

    I appreciate if anyone could help me to write a VBA code or Macro to get it in below format:
    Required View.png

    Timestamp column is the unique key.

    Thanks!

  2. #2
    Forum Contributor mongoose36's Avatar
    Join Date
    06-10-2013
    Location
    Lincoln
    MS-Off Ver
    Excel 2013
    Posts
    389

    Re: VBA code to convert multiple rows as column header grouped by unique key

    copy

    Click on paste special and select transpose.
    If your questions has been answered to your satisfaction please don't forget to do the following:

    Add Reputation ... and ... Mark Thread as Solved

    Thanks,

    Ma 10:8b Freely you have received; freely give.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 02-24-2014, 10:05 AM
  2. Create a row that is a group header for grouped rows by date
    By mramey64 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-09-2013, 11:48 AM
  3. Replies: 0
    Last Post: 04-11-2013, 04:42 PM
  4. Convert iterative but unique data from a column to corresponding rows
    By Marcus2009 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-26-2012, 05:12 PM
  5. Replies: 1
    Last Post: 11-29-2012, 06:24 PM

Tags for this Thread

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