sorting data

[Dundee Lad]

I have a list of names and unique numbers down columns a and b. From columns c onward I have a week eending date as the header and numbers of hours worked. What I need to do is have only 4 columns, name, weekending, unique number and hours. can anyone help?

 

[GorD]

I would do it by following the method in the link below

http://j-walk.com/ss/excel/usertips/tip068.htm.



I imagine you'll have to do it a few times using different data and each time cut and paste the results into access.

Let us know how you get on

 

[Dundee Lad]

Gord, the link does not work

 

[GorD]

I'll try again then

http://j-walk.com/ss/excel/usertips/tip068.htm

think it had an extra . at the end

 

[Norie]

Dundee Lad

I think we really need to see some sample data.

GorD

The technique in that link is a new one on me.

 

[GorD]

I have used it before and it worked quite well at the time.

 

[GorD]

I have used it before and it worked quite well at the time.

 

[Norie]

GorD

But are you sure it will work with the volume of data the OP's mentioned?

I don't think it will, that's why I suggested Access.

 

[GorD]

No I said that in the earlier post, I imagine he would need to have a few goes at it, each time pasting the results into access.

The volume of data remains a problem, but I can't see why spliting the results table up wouldn't work as long as the range used is short enough to return less than 65000 results ( which you wouldn't know before hand)

 

[Norie]

Whoops didn't see the data samples.

I've recently been involved in a thread over in the Access forum that involved converting a 'wide' table into a 'flat' table using pretty straightforward code.

I don't have time at the moment to post a link but it's pretty near the top over there.