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