Turn multiple rows into a single column

**mckaa302** · 05-26-2012, 04:40 PM

Hello!

I am in dire need of help with this one.

I have around 750 rows with 28 numbers in each row that I need changed into one single long column with all the numbers.

Thanks for any help someone can provide!

**Ron Coderre** · 05-26-2012, 05:13 PM

Can you post a shrinky-dink example that shows some starting data and what you want the end result to be?

**mckaa302** · 05-26-2012, 05:38 PM

Yes. Here is a sample excel sheet.

Row 1 is composed of the variables.
Rows 2-5 (Column A) are four different people and then Column B-AC are the scores.

Right now I just did copy/paste special+transpose but to do that 750 times would take hours.

Sample Excel Sheet.xlsx

Thanks for any help you can provide!

**Ron Coderre** · 05-26-2012, 05:52 PM

Using your posted workbook...

These regular formulas will populate the source data in the destination range in the order you want:

Please Login or Register  to view this content.

Copy those formulas down as far as you need.

Is that something you can work with?

**mckaa302** · 05-26-2012, 06:57 PM

Yes!!

That worked perfectly!

Thank you so much!!!

**Ron Coderre** · 05-26-2012, 08:08 PM

Originally Posted by mckaa302

Yes!!
That worked perfectly!
Thank you so much!!!

You're very welcome...Glad to help.

Turn multiple rows into a single column

LinkBack

Thread Tools

Rate This Thread

Display

Turn multiple rows into a single column

Re: Turn multiple rows into a single column

Re: Turn multiple rows into a single column

Re: Turn multiple rows into a single column

Re: Turn multiple rows into a single column

Re: Turn multiple rows into a single column

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions