+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : Transpose cant work

  1. 01-27-2012, 06:59 PM #1
    j790137
    j790137 is offline
    Registered User
    Join Date
    11-01-2011
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    8

    Transpose cant work

    Hi, I have an issue, I have a table of user names and the pc name/s they own, i need to transpose the names to one line (as in sheet2 below)
    I can transpose the data but have 3000 users to copy so it would take too long, do you know if this could be done automacaly in Excel or VBA?
    Thanks

    john




    Sheet1

    john PCname1
    john PCname2
    Paul PCname3
    Davis PCname121
    Davis Pcname 55
    Davis PCname434
    Davis PCname2
    Davis Pcname 755


    Sheet2 transpose.xlsx

    John PCname1 PCname2
    Paul PCname3
    Davis PCname121 Pcname 55 PCname434 PCname2 Pcname 755
    Reply With QuoteRegister To Reply
  2. 01-27-2012, 07:17 PM #2
    JieJenn
    JieJenn is offline
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Transpose cant work

    Not really good with formula but try this code. I think it might do the trick

    Please Login or Register  to view this content.
    Learn Data Analysis or Excel youtube.com/jiejenn
    Reply With QuoteRegister To Reply
  3. 01-27-2012, 07:25 PM #3
    pike
    pike is offline
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Transpose cant work

    or a pivot table will do the trick
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1