I have data in three columns which I would like to transponse like demonstrated on the screenshot below. All the solutions that I have managed to found on the forums so far did not really work for the timestamps since they need to be merged (one unique timestamp per row). The data pattern is always the same, periodical.

Could anyone please help me out on how to achieve the desired result?

How does this work for you? Also, next time please post a workbook as a picture is not workable.

Attached Files

krneki.xlsx (9.8 KB, 11 views)

@krneki
Hi
in free forums where people give you free help on their spare time it is customary to be courteous. "Hello", "thank you",etc.. are not considered foul language.


Furthermore,as you have not done in your earlier posts, you could at least acknowledge the help received so that the persons helping you know they did not waste their time and that the provided solution did ( or did not) solve the problem.
Thank you

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post