URGENT: how Move all column data to row

clwong

New Member
Joined
Mar 17, 2002
Messages
38
Case:
a data sheet with B1-Z1 as Vendor name;
and A2-A100 as Item number;
And B2-Z100 are their corresonding qty

If i want to move row1, i.e.B1-Z1's vendor name, into columnA and columnA to Row1 and all data move their corresponding cells.
How can I do that and it is better send me the Macro example.
Thanks a lot.
my email is :

cl.wong@hongkong.com
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
Hi clwong

If I understand you correctly, you can do this by copy and paste.

Copy the array then use Paste Special and tick the Transpose box

regards
Derek
 
Upvote 0
Derek;
Thanks for your great help.
But my case is more complicated.
could i send u the file?
thanks
 
Upvote 0
Hi
There was no file attached to your e-mail. Please resend to me
regards
Derek
 
Upvote 0
Hi clwong


Try creating a Pivot Table of your data, then Pivot it until it transposed to how you want. Then just 'Copy Paste Special Values' to convert back to raw data.
 
Upvote 0
dear all,

sorry is me again.
after testing for a datasheet with over 256rows, it doesn't work when copy and paste special with transpose.

Error as following:
The information cannot be pasted because the Copy area and teh paste area are not the same size and shape. Try one of the following:.......

any other solution? Thanks.
 
Upvote 0

Forum statistics

Threads
1,213,532
Messages
6,114,177
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top