Transposing decimal data set to a row column timetable

[brendyexcel]

In the image, I'm trying to transpose data that have decimals from the green column onto the orange column and format as seen in the image. I've only included times from 5:30 till 11:45 for the sake of space. My normal process is manually inputting the data but would like thoughts on how to tackle this problem.

I've tried using the excel transpose feature but since the formatting is different in the orange column, it won't produce the same results.

Screenshot 2022-02-22 162443.png

[AliGW]

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.

Administrative Note:

Members will tailor the solutions they offer to the version (NOT release number) of Office (Excel) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this. Thanks.

[kvsrinivasamurthy]

Pl see file
In D2

=IFERROR(INDEX(INT($A$4:$A$33),AGGREGATE(15,6,ROW($A$4:$A$33)/(ISERROR(MATCH(INT($A$4:$A$33),$D$3:$D3,0))),1)-ROW($A$3)),"")

In E2

=TEXTJOIN(" ",TRUE,IF(INT($A$4:$A$33)=D4,TEXT(100*MOD($A$4:$A$33,1),"00"),""))

[brendyexcel]

Thank you, this helps a lot!