Results 1 to 1 of 1

Transposing columns to rows (while skipping rows)

Threaded View

  1. #1
    Registered User
    Join Date
    02-09-2015
    Location
    Los Angeles, California
    MS-Off Ver
    MS Office 2010
    Posts
    17

    Transposing columns to rows (while skipping rows)

    This may seem like a basic question, but I am trying to transpose data in a column so that it formats horizontally in a row (without using the copy paste special function because I want this to be a constantly automated format). The caveat is that I want to skip every other row in the initial columns. In other words, the final result should be single rows of data that populate data from every other row in the initial columns. For example, the initial format...

    Column A      Column B     Column C
    2/2/2015      1                 50
    2/2/2015      2                 100
    2/3/2015      3                 150
    2/3/2015      4                 200
    2/4/2015      5                 250
    2/4/2015      6                 300
    2/5/2015      7                 350
    2/5/2015      8                 400
    ...should ultimately look like this...
    Column D    Column E    Column F     Column G
    2/2/2015     2/3/2015     2/4/2015     2/5/2015
    1                3               5               7
    2                4               6               8
    50              150            250            350
    100            200            300            400
    Any help would be greatly appreciated. Thanks!
    Last edited by JBeaucaire; 02-09-2015 at 07:12 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Skipping Rows, Transposing Data, and Who Knows What Else!
    By rcollins00 in forum Excel General
    Replies: 2
    Last Post: 04-12-2016, 01:09 PM
  2. Transposing rows to columns while skipping a cell
    By jocelyn.gillespie in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-06-2014, 08:12 PM
  3. [SOLVED] Need help with transposing columns to rows
    By cheryl_granieri in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-20-2013, 09:14 AM
  4. Transposing columns to rows
    By sunitagadapu in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-06-2009, 08:54 AM
  5. [SOLVED] Skipping Columns/Rows
    By Lilbit in forum Excel General
    Replies: 2
    Last Post: 09-28-2005, 03:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1