+ Reply to Thread
Results 1 to 3 of 3

Macro needed to transpose data

  1. #1
    Registered User
    Join Date
    08-07-2018
    Location
    London
    MS-Off Ver
    365
    Posts
    5

    Macro needed to transpose data

    Hi folks,

    I am working with quite a messy spreadsheet containing raw data, which I need to format into a clean and usable format for other software programs. The spreadsheet is about 600 rows long and contains data points, grouped together in the same row, which need to be separated into different columns. I need a macro to be able to scan through the spreadsheet, transposing the data it finds in groups of 2 cells into separate columns, while ignoring all the random gaps in the spreadsheet. I have attached an example spreadsheet, which shows what my raw starting data looks like and the desired output.

    Cheers
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    365 32bit
    Posts
    214

    Re: Macro needed to transpose data

    Maybe something like this:
    Please Login or Register  to view this content.

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    17,895

    Re: Macro needed to transpose data

    Change "j1" to suite.
    Please Login or Register  to view this content.

+ 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. Correction needed for transpose macro
    By genetist in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-08-2014, 04:03 AM
  2. Replies: 1
    Last Post: 06-30-2014, 07:23 PM
  3. Help needed for a MACRO to transpose data from multiple variable columns into rows.
    By excel_starter in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-30-2014, 02:30 PM
  4. [SOLVED] VBA / Macro / Formula help needed for extracting data and Transpose into another sheet
    By krjoshi in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 02-05-2014, 12:19 PM
  5. [SOLVED] Need to Transpose and Flip Table of Data - Macro Probably Needed
    By BobTomlinson in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-08-2013, 09:25 AM
  6. [SOLVED] VB code Macro needed to transpose data from columns to rows
    By raw_geek in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-20-2012, 08:54 AM
  7. urgent transpose macro needed -
    By barkiny in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-06-2006, 12:12 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