How to use a fomula to spread data horizontal from a vertical list

[wec43wec]

I would like to know if there is an easy way to create a formula that will copy horizontal data from data in cells that are listed vertically?


Example

Sheet 1

Current location of data to be copied - a1 thru a10


Sheet 2

I need to create a formula that will list the data (horizontal) in cells B2 thru K2 by using the “=” or “+” formula sign


Note; Sample results

Sheet 2 (Result sheet)

Cell sheet2!B2 will contain data from sheet1!a1
Cell sheet2!C2 will contain data from sheet1!a2
Cell sheet2!D2 will contain data from sheet1!a3
Thru
Cell sheet2!k2 will contain data from sheet1!a10


I am aware of the transpose function, but I have over 1000 lines of data that I would need to copy from sheet 1 to sheet 2. The pivot table options give me data that I can transpose, however I need this to be automatic.

Each week I will be dropping data from a database into sheet 1. From sheet 1 I will pull this data into sheet 2 using the "+" or "=" formula.

Thanks

 

[mrdenny]

You'll want to post this in the Office forum forum68 or forum707.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[wec43wec]

Sorry, I thought I was in the MS Office foruum.