I work with scheduling software that generates text reports. The data is displayed in a vertical format, but I would like to transpose the information into one horizontal line per employee number.
Attached is a sample spreadsheet that I've generated with two worksheets; one entitled "Original Report" and the other one entitled "What I want."
Any help is appreciated. I'm not very good at Visual Basic.
Bookmarks