Hello,
I found this forum on Google after trawling for suitable methods of completing a task I've come up against.
The Task:
Essentially I have a sheet with 10000~ rows and 2 columns. First I need to match cell data in column A (NetBIOS names) and where there's a match I need the data transposed from column B into column C,D,E,F etc where applicable.
I have attached a small sample of the workbook, sheet1 (Thanks) which shows the data for the task at hand, sheet2 (Expected End Result) is what I hope the data would look like when the macro has been run.
If there's an easier solution that I'm missing, I am all ears.
Thanks in advance, James
Bookmarks