Moving large amount of data

[WHSCC]

In a Microsoft Excel worksheet I want to move large amounts of data in
multiple rows in to columns. How can this be done?

 

[Jan De Messemaeker]

Hi,

Maybe somebody will be able to help you but why post this in teh NG
dedicated to MS project? there are Excel Newsgroups.
HTH

 

[Steve House [MVP]]

You get best answers in an Excel newsgroup, but the quick answer is to
select the data, do Edit Copy, then Edit Paste Special, Transpose. But
rmemeber, there are only 256 columns so if you're transposing rows into
columns and columns into rows, you can only have a maximum of 255 rows in
your source data before you run out of room in the target range.