1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Multiple Vertical Columns into 1 Horizontal Row

Discussion in 'Business Applications' started by Cambium, Aug 20, 2012.

Thread Status:
Not open for further replies.
  1. Cambium

    Cambium Thread Starter

    Oct 9, 2011
    Is there a way to do this without copying and pasting every column into one row?

    My goal is to get a continuous line chart that shows 63 years worth of monthly data.

    Using Excel 2010.

    Thanks all.
  2. draceplace


    Jun 8, 2001
    Some ideas....
    You can select a column and do a copy/paste special and pick 'transpose' and it will flatten the vertical row. It will not work if you select the whole column. You have to select the populated fields in the column.

    vbscript / macro to read down each column of sheet1 and write to row1 in sheet2 would be ideal. Not sure how many columns you can have in Excel?

    I would think there would be a way to auto file a link going across. =Sheet1!A1, Sheet!A2...Sheet!A12, Sheet!B1...
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1065862