Moving large amount of data

[Guest]

In an excel worksheet, I have a large amount of data in multiple rows and I
want to move the data from rows to columns. The amount of data is too large
to cut and past. How can this be done?

 

[Scott McDaniel]

This is an Access newsgroup; you'll get better answers in a newsgroup
devoted to Excel.

 

[Van T. Dinh]

Check Excel Help topic "Transpose rows to columns or columns to rows".

BTW, you posted to the wrong newsgroup. This newsgroup is for Microsoft
Access, a database application.

If you still need help, suggest you post to one of the Excel newsgroups.

 

[Joseph Meehan]

In an excel worksheet, I have a large amount of data in multiple rows
and I want to move the data from rows to columns. The amount of data
is too large to cut and past. How can this be done?

In addition to the comments already made, If you are working with larger
amounts of data, Excel has a rather low limit on the number of rows it will
allow. You can have over a million records (rows) in Access. In general
Access is a better product for handling large amounts of data. It does have
the disadvantage of having a steep learning curve howerver.