Results 1 to 4 of 4

Thread: Transpose Tables arranged horizontally to vertically

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 03-22-2018, 11:12 AM #1
    RINCONPAUL
    RINCONPAUL is offline
    VBAX Tutor
    Joined
    Jul 2015
    Posts
    212
    Location

    Transpose Tables arranged horizontally to vertically

    I need to transpose groups of table data displayed horizontally and stack them vertically keeping common col A,B,C,D reference. The attached example shows sheet "Display1" as the current situation and sheet "Display2" the desired situation.
    The real life scenario differs in that there are 14 tables horizontally, each with 12 headers. Some data in cells of tables will be blank! The row count for each "Event" varies and the number off.

    Thanks
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules