how to align vertical cells horizontally

T

Trice

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
 
C

CLR

A Pivot Table might well give you the results you're looking for.

Vaya con Dios,
Chuck, CABGx3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Time and Date 2
Using variable names in a loop 3
Importing CSV Data from Web? 0
How do I automatically move vertical cells horizontally? 0
need help: time difference between two ceels in a column 1
CrossTab/Source Relation 2
How to create a report like... 1
Adding Time to a Date 1

Top