PDA

View Full Version : Transponse each n rows + merge rows periodically



krneki
11-20-2018, 03:21 PM
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?

https://i.imgur.com/DfJNCiw.png

Paul_Hossler
11-21-2018, 06:32 AM
is the data always so regular?


Time - A - B - C

Time - A - B - C

Time - A - B - C


etc.?