Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-12-2012, 04:17 AM
PRADEEPB270's Avatar
PRADEEPB270 PRADEEPB270 is offline How to transpose the datas of part code and supplier into row and column Windows Vista How to transpose the datas of part code and supplier into row and column Office 2007
Novice
How to transpose the datas of part code and supplier into row and column
 
Join Date: Aug 2011
Location: Gurgaon-INDIA
Posts: 17
PRADEEPB270 is on a distinguished road
Default How to transpose the datas of part code and supplier into row and column

I have a file having so many part code and supplier of each part code.



Now,I want that a part code should appear at once in a row and each supplier of that part code against that column.

Please refer attach file for more clarification.
In this file,column B and C consists of Part code and supplier.But the reqd.result is appearing from E to K column.

Is it possible from an excel formula?
Attached Files
File Type: xlsx Book1.xlsx (8.7 KB, 3 views)
Reply With Quote
  #2  
Old 10-17-2012, 02:03 AM
PRADEEPB270's Avatar
PRADEEPB270 PRADEEPB270 is offline How to transpose the datas of part code and supplier into row and column Windows Vista How to transpose the datas of part code and supplier into row and column Office 2007
Novice
How to transpose the datas of part code and supplier into row and column
 
Join Date: Aug 2011
Location: Gurgaon-INDIA
Posts: 17
PRADEEPB270 is on a distinguished road
Default To explain the macro-enabled working in a file

A person has sent to me a file which is macro-enabled file.Can anybody help me to understand the file step-by-step that how has he worked out in this file?I am unable to self understand the working of that file.
For more clarification,please refer the attach file.
Attached Files
File Type: xlsm Pradeep.xlsm (18.8 KB, 1 views)
Reply With Quote
  #3  
Old 10-26-2012, 07:18 PM
macropod's Avatar
macropod macropod is online now How to transpose the datas of part code and supplier into row and column Windows 7 64bit How to transpose the datas of part code and supplier into row and column Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,224
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

Yes, it's possible, but the formulae are complex. See:
http://windowssecrets.com/forums/sho...l=1#post734296
http://www.techsupportforum.com/foru...ml#post2567119
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #4  
Old 10-26-2012, 07:22 PM
macropod's Avatar
macropod macropod is online now How to transpose the datas of part code and supplier into row and column Windows 7 64bit How to transpose the datas of part code and supplier into row and column Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,224
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

Quote:
Originally Posted by PRADEEPB270 View Post
A person has sent to me a file which is macro-enabled file.
That suggests you have posted a question about the same issue in another forum. If so, please read: http://www.excelguru.ca/content.php?184 and post a link here to your thread in that forum. Do likewise for the other forum also.
Quote:
Can anybody help me to understand the file step-by-step that how has he worked out in this file?I am unable to self understand the working of that file.
Have you had a look at the macro code? Have you asked the person who provided it to explain it?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to Rename a Quick Part sleake Word 14 10-14-2013 09:21 AM
VBA code for count w and write into another column in excel tomlam Excel Programming 2 10-09-2012 03:56 AM
How to obtain the column C from column A and B? Jamal NUMAN Excel 2 02-26-2012 01:28 PM
Can I change the horizontal scrollbar to scroll smoothly rather than column by column carpat Excel 0 01-10-2012 09:34 AM
How to transpose the datas of part code and supplier into row and column Need to search a column for a macth and return a result from a third column pdfaust Excel 2 02-03-2011 03:02 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:19 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft