| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how to align vertical cells horizontally
Group by date and automatically change this:
Date1 Time1 Reading1 Date1 Time2 Reading2 Date1 Time3 Reading3 Date2 Time1 Reading1 Date2 Time2 Reading2 Date3 Time1 Reading1 Date3 Time2 Reading2 Date3 Time3 Reading3 Date3 Time4 Reading4 to this: Date1 Time1 Reading1 Time2 Reading2 Time3 Reading3 Date2 Time1 Reading1 Time2 Reading2 Date3 Time1 Reading1 Time2 Reading2 Time3 Reading3 Time4 Reading4 |
|
#2
|
|||
|
|||
|
A Pivot Table might well give you the results you're looking for.
Vaya con Dios, Chuck, CABGx3 "Trice" wrote: Group by date and automatically change this: Date1 Time1 Reading1 Date1 Time2 Reading2 Date1 Time3 Reading3 Date2 Time1 Reading1 Date2 Time2 Reading2 Date3 Time1 Reading1 Date3 Time2 Reading2 Date3 Time3 Reading3 Date3 Time4 Reading4 to this: Date1 Time1 Reading1 Time2 Reading2 Time3 Reading3 Date2 Time1 Reading1 Time2 Reading2 Date3 Time1 Reading1 Time2 Reading2 Time3 Reading3 Time4 Reading4 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Order of selecting unprotected cells | Excel Discussion (Misc queries) | |||
| how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
| Unlocking Cells when a worksheet is protected... | Excel Discussion (Misc queries) | |||
| Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Linear Mode
