How to transpose multiple rows with 24 cells each to a single column continuous.

[kayafueya]

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

[FDibbins]

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))

[FDibbins]

Happy to help and thanks for the feedback

[alansidman]

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.

[Rick Rothstein]

...and thanks for the feedback

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.

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.

[FDibbins]

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.

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.

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