Results 1 to 4 of 4

Thread: [RESOLVED] Convert 2000 columns to a single one

  1. Dec 20th, 2018, 04:40 AM #1
    tmealha
    tmealha is offline

    Thread Starter
    New Member
    Join Date
    Oct 2018
    Posts
    11

    Resolved [RESOLVED] Convert 2000 columns to a single one

    Hi guys,

    I have an Excel file with one row and more than 2000 columns. Can someone explain me how can I turn this into one single column/cell? Basically turn a table 1X2000 to a 1X1.

    Thanks in advance.
    Reply With Quote Reply With Quote
  2. Dec 20th, 2018, 05:50 AM #2
    Ecniv
    Ecniv is offline
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343

    Re: Convert 2000 columns to a single one

    Select the lot.
    Use the excel function transpose
    A quick google search gave the link above...

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...
    Reply With Quote Reply With Quote
  3. Dec 20th, 2018, 09:49 AM #3
    tmealha
    tmealha is offline

    Thread Starter
    New Member
    Join Date
    Oct 2018
    Posts
    11

    Re: Convert 2000 columns to a single one

    Thanks Ecniv!
    Reply With Quote Reply With Quote
  4. Dec 21st, 2018, 06:13 AM #4
    Ecniv
    Ecniv is offline
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343

    Re: Convert 2000 columns to a single one

    no problem.
    If this resolves the question, at the top of your original post should be a thread tools. Select it and select mark as resolve

    Have a great day!

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Tags for this 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


Click Here to Expand Forum to Full Width