transpose spreed data in 10-25 row to one row
 

Hello
I have traspose data from a sheet (vert) to another (horizontal)
date start stop used
02.feb 2 08:40 09:30 0:50
02.feb 2 12:00 14:00 2:00
02.feb 2 20:00 22:30 2:30
02.feb
06.jun 6 0:00
06.jun 6 0:00
06.jun 6 0:00

But i need to a help to controlled so just first cell indicate startdate,
and next cell (b1) view first start, d1 second start. d1 and e1 view used
time.
There could be 10-25 starttime and usedtime, but it is only A1 how indicate
date.
Start1 Used Start2 Used Start3 used
02.feb 08:40 00:50 05:00 01:00 08:30 05:00 14:00
03.feb 07:00 01:00
04.feb 08:00 02:00
05.feb 05:00 03:00
Can anyone give me a hint

dagfinn

--
eet

dagfinn skrev:

Hello
I have traspose data from a sheet (vert) to another (horizontal)
date start stop used
02.feb 2 08:40 09:30 0:50
02.feb 2 12:00 14:00 2:00
02.feb 2 20:00 22:30 2:30
02.feb
06.jun 6 0:00
06.jun 6 0:00
06.jun 6 0:00

But i need to a help to controlled so just first cell indicate startdate,
and next cell (b1) view first start, d1 second start. c1 and e1 view used
time.
There could be 10-25 starttime and usedtime, but it is only A1 how indicate
date.
Start1 Used Start2 Used Start3 used
02.feb 08:40 00:50 05:00 01:00 08:30 05:00 14:00
03.feb 07:00 01:00
04.feb 08:00 02:00
05.feb 05:00 03:00
Can anyone give me a hint

dagfinn

--
eet