+ Reply to Thread
Results 1 to 2 of 2

Columns to rows by a macro

  1. 09-16-2013, 03:11 AM #1
    isha3
    isha3 is offline
    Registered User
    Join Date
    09-13-2013
    Location
    Lebanon
    MS-Off Ver
    Excel 2010
    Posts
    4

    Columns to rows by a macro

    Dear Experts,
    i have this original data in sheet1 i need it to be displayed as in sheet2
    i'll be very thank full for your help and assistance.
    best regards,report.xlsx
    Attached Images Attached Images
    Last edited by isha3; 09-16-2013 at 08:04 AM.
    Reply With QuoteRegister To Reply
  2. 09-16-2013, 05:38 PM #2
    tony h
    tony h is offline
    Valued Forum Contributor tony h's Avatar
    Join Date
    03-14-2005
    Location
    England: London and Lincolnshire
    Posts
    1,187

    Re: Columns to rows by a macro

    select the text (ctrl+shift+* may help) then copy then paste special ... transpose


    click on the * Add Reputation if this was useful or entertaining.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Columns to rows by a macro
    By isha3 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-13-2013, 04:15 AM
  2. Hiding columns using a macro after rows have been filtered using a macro
    By ivandc1234 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-26-2013, 06:24 PM
  3. [SOLVED] Switch rows to columns in a Macro
    By fassn in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-05-2013, 07:13 AM
  4. Moving Rows and Columns with a Macro
    By mtcnd2002 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-27-2009, 04:28 PM
  5. macro to export from columns to rows
    By geooil in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-19-2005, 05:11 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1