There's no such thing as a stupid question, but they're the easiest to answer.


Search Search
Search for:
Tech Support Guy > > >

Multiple Vertical Columns into 1 Horizontal Row


Cambium's Avatar
Cambium Cambium is offline
Computer Specs
Member with 60 posts.
Join Date: Oct 2011
Location: Connecticut
Experience: Intermediate
20-Aug-2012, 06:14 PM #1
Multiple Vertical Columns into 1 Horizontal Row
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.
draceplace's Avatar
draceplace   (Dan) draceplace is offline
Computer Specs
Member with 2,037 posts.
Join Date: Jun 2001
Location: Conway, Arkansas
21-Aug-2012, 11:25 AM #2
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

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine

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.

excel, horizontal, multiple columns, row

Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools

You Are Using: Server ID
Trusted Website Back to the Top ↑