URGENT: how Move all column data to row

[clwong]

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

 

[Dave Hawley]

Hi clwong


Excel has a Column limit of 256 which cannot be increased.

Not sure why you need to Transpose an entire table, but a Pivot Table of you data may help you out. You will of course still be bounded by 256 columns.

 

[clwong]

Thanks Dave Hawley

Oh no.....as it is requested from my boss....
any other alternative? Macro?...VBA.....

 

[Dave Hawley]

No not really, tell your boss Excel is not desingned to have data laid out this way! The best that could be done is spread it over more than one sheet (not advised), or set up a Pivot Table, then you boss will get himself confused and/or excited Pivoting the data.

I must ask why does you boss want to Transpose an entire table???