I have a file as attached and the idea is to populate sheet2 with the values from sheet1 across each column. the attached file shows how i intend sheet2 to look like from sheet1 but as I have hundreds of rows of data, copy paste transpose wont be efficient. any help is much appreciated. thanks
Last edited by purple_rain09; 08-19-2019 at 08:36 AM.
Hi
Into B2 on sheet2:
Formula:
Please Login or Register to view this content.
accept with Ctrl+Shift+Enter and drag it right and down.
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
Thank you very much!
You welcome. Happy to help.
Thanks for rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks