Results 1 to 3 of 3

Macro needed to transpose data

Threaded View

  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

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