Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Trying to transpose linked data using Paste Special | Excel Worksheet Functions | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
create an alert when the entered data is already in the spreed sh. | Excel Worksheet Functions | |||
transpose data | Excel Worksheet Functions | |||
How can I transpose data from a spreadsheet into a form that does. | Excel Worksheet Functions |