| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Linear Mode
