LinkBack URL
About LinkBacks
Hello,
Kindly help me with this. I want to transpose multiple rows with 24 cells each to a single continuous single column. See attached files. Thank you so much for the response
From
1.PNG
to
Attachment 666096
Hello,
Kindly help me with this. I want to transpose multiple rows with 24 cells each to a single continuous single column. See attached files. Thank you so much for the response
From
1.PNG
to
Attachment 666096
If you will already have the date and hour, as per sample, you could use this in E3, copied down...
=INDEX(RAW!$C$2:$Z$6,MATCH(Sheet1!B3,RAW!$B$2:$B$6,0),MATCH(Sheet1!C3,RAW!$C$1:$Z$1,0))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Happy to help and thanks for the feedback
An alternative solution is to use Power Query and unpivot the columns. Here is the Mcode and I have attached the file for your review.
Please Login or Register to view this content.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
What feedback? All I see is the OP's original message and then Messages #2 and #3, both of them from you! Since the thread is not marked SOLVED, I am wondering if I somehow missed something.Originally Posted by FDibbins
EDIT NOTE: Since posting, a message from alansidman just popped in at Message #4 spot (must have been posted while I was typing), but I still do not see the message you apparently replied to.
Last edited by Rick Rothstein; 03-07-2020 at 11:15 AM.
Rick, OP gave me a rep, and posted a thanks to me in it. Guess I should have posted that here, will try and remember for next time so as to save others from working on a solved thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks