I currently have a situation where information is entered on sheet1 on several rows. Example:
I want to copy the information in column B to sheet2 and have the information transposed to a single row with multiple columns. Example:![]()
Please Login or Register to view this content.
I know this can be done with the transpose function but I want to do it with a button click.![]()
Please Login or Register to view this content.
Thanks in advance!
Bookmarks