Software

Ask something
Discussion Locked

Table to linier

0 helpful
2 replies

by navjun

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a table in excel that I like to convert to lienier in excel , let me be more clear.
I have colums that are days of the month and then rows that are name of each month and the were they meet are the time of sun set/rise or both
ie:
Jan Feb March
1 6 6:10 6:15
2 6:02 ... ...
3 6:03 ... ..
4 ... .... ...

and so on
I like to make them linier
as follows
One cooulum holding the date and one the time
Date rise set
jan 1 6:00 ...
jan 2 6:02 ...

and so on

please help

2 replies

by dryflies

DOM Jan Feb March
1 6 6:10 6:15
2 6:02 ... ...
3 6:03 ... ..
4
Add DOM for day of month. create an empty table (linear)with three fields, month, DOM, .
create a delete query that empties the table.
Create a query for each month to get the data for that month: SELECT [DOM],[jan] from TABLE. that is the basic syntax it is easier to do with the designer. Make them all append queries to append into "linear" next create a macro that calls first the delete query and then each of the month queries in turn using the openquery command.

This discussion is closed to new replies.