Results 1 to 19 of 19

Pull data horizontally and place vertically 3 by 3

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-02-2016
    Location
    brasil
    MS-Off Ver
    office 365 2016 windows
    Posts
    195

    Pull data horizontally and place vertically 3 by 3

    Hi all. I tried to get it done by myself without success. I have a table with duedates payment status and ammount diplayed horizontally. Each block of 3 cells are DUEDATE STATUS AMMOUNT. There are 6 blocks of 3 cells. I need to list vertically those blocks of 3 cells skipping blanks.

    I have attached a sample detailed worksheet.

    Thanks in advance.
    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. How to Tile Blocks of Data Horizontally Instead of Vertically
    By Meagangineer in forum Excel General
    Replies: 2
    Last Post: 11-07-2016, 03:31 PM
  2. Vertically data into horizontally of repeated numbers
    By gondal in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-04-2016, 01:08 PM
  3. Display data horizontally not vertically through VBA
    By webanalytics1 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-27-2015, 10:44 AM
  4. [SOLVED] transpose and consolidate data horizontally to vertically
    By Excel_learner in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-04-2014, 03:50 PM
  5. Need to match a variable vertically and pull a value horizontally
    By bone7890 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-09-2013, 03:20 PM
  6. Excel 2007 : Merging data horizontally vs. vertically
    By enhydra in forum Excel General
    Replies: 4
    Last Post: 12-12-2010, 06:16 PM
  7. A tough one! line up vertically/horizontally through data
    By djvice in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-14-2005, 04:32 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