+ Reply to Thread
Results 1 to 7 of 7

Transpose into separate columns

  1. 07-25-2017, 02:24 PM #1
    AaruJaan
    AaruJaan is offline
    Forum Contributor
    Join Date
    01-23-2016
    Location
    karachi
    MS-Off Ver
    2007
    Posts
    316

    Transpose into separate columns

    Hello Experts,

    I have contact details list in Column A and I want to transpose the contact in specific columns, every line with next line no gape between the lines, please check the screenshots.

    Thanks in advance

    Farhan
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
  2. 07-25-2017, 02:27 PM #2
    mehmetcik
    mehmetcik is offline
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Transpose into separate columns

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.
    Reply With QuoteRegister To Reply
  3. 07-25-2017, 02:31 PM #3
    AaruJaan
    AaruJaan is offline
    Forum Contributor
    Join Date
    01-23-2016
    Location
    karachi
    MS-Off Ver
    2007
    Posts
    316

    Re: Transpose into separate columns

    Excel File
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 07-25-2017, 02:37 PM #4
    sktneer
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: Transpose into separate columns

    Try this...
    Please Login or Register  to view this content.
    Regards
    sktneer

    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.
    Reply With QuoteRegister To Reply
  5. 07-25-2017, 02:46 PM #5
    mehmetcik
    mehmetcik is offline
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Transpose into separate columns

    Paste this formula into B3

    Fill right

    Fill down until you get a line of zeros.


    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    Or fill this formula down until you get blank lines.

    Please Login or Register  to view this content.
    Last edited by mehmetcik; 07-25-2017 at 02:49 PM.
    Reply With QuoteRegister To Reply
  6. 07-25-2017, 02:47 PM #6
    AaruJaan
    AaruJaan is offline
    Forum Contributor
    Join Date
    01-23-2016
    Location
    karachi
    MS-Off Ver
    2007
    Posts
    316

    Re: Transpose into separate columns

    Hi Sktneer,

    Thanks for reply, I don't want to remove column A Data
    Reply With QuoteRegister To Reply
  7. 07-25-2017, 02:49 PM #7
    sktneer
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: Transpose into separate columns

    Then remove the following line from the code.
    Please Login or Register  to view this content.
    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. Macro to separate long string of characters and several spaces into separate columns
    By taylorsm in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-31-2017, 07:37 PM
  2. Adapt WorkSheet Transpose Function to work with separate Workbooks
    By coreytroy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-25-2014, 06:00 AM
  3. [SOLVED] Match Multiple Columns from Separate Sheet to get separate column.
    By gvitoro in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-19-2014, 03:38 PM
  4. [SOLVED] Separate numeric/text combination into two separate columns.
    By Jim15 in forum Excel General
    Replies: 6
    Last Post: 10-09-2013, 05:49 PM
  5. Transpose Duplicate Rows to Separate Columns
    By VEL in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-26-2012, 01:08 PM
  6. Need Macro to transpose multiple rows to detailed columns and separate city, state, zip
    By taboucher in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-14-2012, 04:47 PM
  7. Transpose 2 separate blocks of info into 1 row.
    By jamesb01 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-14-2008, 11:14 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1