View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Suwat Upathambhakul (Thailand) Suwat Upathambhakul (Thailand) is offline
external usenet poster
 
Posts: 6
Default how to change data from horizontal to be vertical (Excel 2007)

Dear Sheeloo

your advise is helpful, I sent my file to wikiend.com as per your advice,

thanks again,
rgds, suwat u.

"Sheeloo" wrote:


NO.

I upload to a site like wikisend.com and paste the link...

You can mail it to me...

"Suwat Upathambhakul (Thailand)" wrote:

Dear Sheeloo

thank you so much, but we have many many finished goods, do you know how to
attach file into this forum ?

thank you so much,


"Sheeloo" wrote:

Copy the data you want...
Select a cell outside the copied area
Right click, choose Paste Special and select Transpose...
--
Pl click the YES button
(if you see it - don''''''''t worry if you don''t),
if this answer was helpful.



"Suwat Upathambhakul (Thailand)" wrote:

Bill of materials for many Finished goods showing Raw materials in
horizontal, I would like to change Raw Materials from horizontal to vertical.

Kindly advised how to do that.

thanks and best regards,
suwat upathambhakul