Results 1 to 24 of 24

How to Transpose Column into Rows

Threaded View

  1. 05-11-2020, 04:16 PM #1
    carlton7372
    carlton7372 is offline
    Registered User
    Join Date
    09-14-2015
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    83

    How to Transpose Column into Rows

    Hello Community,

    Can someone please show me how to transpose a column of cells in rows.

    In the attached csv you will see column A has the following cells, Company, Sector, industry, continent, country, marketvalue, sales, profits, assests, rank and forbeswebpage. These cells I would like transposed (if that is the right word to use) into a their own fields / columns as shown in cols D to N. I would then like the corresponding fields filled in as shown from D2 to N2, D3 to N3, and D4 to N4.

    Can you help me with that?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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. Transpose rows to column and insert new rows to fill in data
    By Apple Ling in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-24-2019, 04:02 AM
  2. [SOLVED] VBA How to Transpose Rows to Column
    By voda4444 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-16-2018, 12:13 PM
  3. Transpose 2 rows to column
    By rontabz in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-16-2017, 11:37 AM
  4. Transpose every 5 cells in column A to indidual rows in column B
    By meridklt in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-14-2013, 12:35 AM
  5. Insert rows, transpose data from column in to rows, in steps
    By mchevalier in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-01-2012, 08:14 PM
  6. Transpose rows to column
    By MaxBrit in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-18-2005, 03:07 AM
  7. transpose a column into many rows
    By GMed in forum Excel General
    Replies: 1
    Last Post: 01-21-2005, 04:06 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