URGENT: how Move all column data to row

clwong · Mar 18th, 2002, 03:22 AM

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

Derek · Mar 18th, 2002, 03:40 AM

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

clwong · Mar 18th, 2002, 03:51 AM

Derek;
Thanks for your great help.
But my case is more complicated.
could i send u the file?
thanks

Derek · Mar 18th, 2002, 03:54 AM

Sure,
d.baldry@path.com.au
regards
Derek

clwong · Mar 18th, 2002, 04:06 AM

Derek,
Already sent.
Thanks.

Derek · Mar 18th, 2002, 05:29 PM

Hi
There was no file attached to your e-mail. Please resend to me
regards
Derek

Juan Pablo González · Mar 18th, 2002, 07:48 PM

Wouldn't it be easier to post some example data ?

Dave Hawley · Mar 18th, 2002, 08:32 PM

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.

clwong · Mar 18th, 2002, 09:29 PM

Thanks all.
already done.

clwong · Mar 19th, 2002, 01:52 AM

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.

Mar 18th, 2002, 07:48 PM	#7
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	Wouldn't it be easier to post some example data ? __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 18th, 2002, 03:22 AM	#1
clwong New Member Join Date: Mar 2002 Location: Hong Kong Posts: 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

Mar 18th, 2002, 03:40 AM	#2
Derek Board Regular Join Date: Feb 2002 Location: Perth Australia Posts: 1,567	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

Mar 18th, 2002, 03:51 AM	#3
clwong New Member Join Date: Mar 2002 Location: Hong Kong Posts: 38	Derek; Thanks for your great help. But my case is more complicated. could i send u the file? thanks

Mar 18th, 2002, 03:54 AM	#4
Derek Board Regular Join Date: Feb 2002 Location: Perth Australia Posts: 1,567	Sure, d.baldry@path.com.au regards Derek

Mar 18th, 2002, 04:06 AM	#5
clwong New Member Join Date: Mar 2002 Location: Hong Kong Posts: 38	Derek, Already sent. Thanks.

Mar 18th, 2002, 05:29 PM	#6
Derek Board Regular Join Date: Feb 2002 Location: Perth Australia Posts: 1,567	Hi There was no file attached to your e-mail. Please resend to me regards Derek

Mar 18th, 2002, 08:32 PM	#8
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	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.

Mar 18th, 2002, 09:29 PM	#9
clwong New Member Join Date: Mar 2002 Location: Hong Kong Posts: 38	Thanks all. already done.

Mar 19th, 2002, 01:52 AM	#10
clwong New Member Join Date: Mar 2002 Location: Hong Kong Posts: 38	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.