+ Reply to Thread
Results 1 to 2 of 2

Transpose Columns to Rows 12 Cells at a Time

  1. #1
    Registered User
    Join Date
    02-04-2020
    Location
    NY, NY
    MS-Off Ver
    Office Standard 2013
    Posts
    1

    Transpose Columns to Rows 12 Cells at a Time

    I have a spreadsheet that reports on database errors. Unfortunately, it arranges the errors in two columns, A is Labels and B is the data for the labels. Normally I just use Copy & Transpose Paste and do it manually, but due to a major incident, this report is currently several thousand lines. I tried using Offset and even Offset(Row) formulas, but either I'm doing something wrong, or I need another method. I attached a sample sheet with just a couple of errors and the errors transposed manually to show what I need, as well as examples of the two formulas I tried. Anybody have any ideas?

    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Transpose Columns to Rows 12 Cells at a Time

    Is the Message always 5 rows deep, and the Remedy always 2 rows ?

    If they can vary, then you might need to use a helper column to count these. Do you always have those same headings in column A?

    Pete

+ 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. [SOLVED] Macro to transpose rows into columns and paste to specific columns in another sheet
    By LDLDLD in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-05-2019, 11:08 AM
  2. Transpose Columns into Rows based on Unique Identifier for n columns
    By bhavt010785 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-01-2017, 11:55 AM
  3. [SOLVED] Formula to transpose rows to new columns and columns to new rows in Excel
    By bjnockle in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-26-2014, 06:28 PM
  4. [SOLVED] Transpose Duplicate rows into columns including blank cells
    By BJPhil in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-07-2014, 12:08 PM
  5. Replies: 1
    Last Post: 01-24-2014, 06:20 PM
  6. Replies: 2
    Last Post: 01-01-2012, 05:54 AM
  7. transpose data between columns, rows or cells
    By jonnel in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 07-31-2006, 09:28 AM

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