View Single Post
  #7   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 Fred smith

thank you so much, sorry for my mistake, this is the my first post, I think
I should better create a new post for easy understanding.

rgds, suwat u.

"Fred Smith" wrote:

This forum does not accept attachments, because of the risk of viruses.

All you need to do is explain your problem clearly, and you will get a
quick, accurate response. You can start with explaining why Sheeloo's
response didn't help you. It looked like it accurately answered the question
to me.

If you insist, you can store your file at a third-party hosting site, and
post the link here, but don't be surprised if there aren't any takers.

Regards,
Fred.


"Suwat Upathambhakul (Thailand)"
. com wrote in message
...
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