The ida.. of re-organising the original data

Copy paste from web pages or word or even excel to a *post* usually gets
messed up with tabs and hidden *newlines*

Emails tend to support these better, leading spaces etc etc
never easy

Steve

On Fri, 08 Sep 2006 09:36:22 +0100, Epinn
wrote:

Steve,

But the idea is the same......

What idea? My idea of four columns and sorting which I posted
**before** you did OR the idea of "copy and paste" to a post vs. email?
I don't know if you are aware that I said my table (second one) looked
okay in an *email*. In other words, I did plan my layout well. I just
don't understand why it was all off when I pasted the exact same table
to a *post*. Totally lost why posts always give me a problem when
emails won't.

......move/plan data layout so that it can be used easily.

Of course, I have lots of experience in designing record layouts etc.
although I may be new to Excel.

Cheers,

Epinn

"SteveW" wrote in message
news:op.tfjuooj7evjsnp@enigma03...
The first format was clear :)
But the idea is the same, move/plan data layout so that it can be used
easily
Bit like entering names as "Surname, FirstName" or better in 2 cells
So many put all the names in as "FirstName Surname" and then want to sort
by Surname

Cheers, Steve


On Fri, 08 Sep 2006 08:26:40 +0100, Epinn
wrote:

Sorry, the alignment of the table was off. Let me try again.

Floor
Room #.
Wake-up call at
Newspaper
1
102
6.00
Y
2
202
6.00
N
2
207
6.00
N
1
103
6.25
Y
2
203
6.25
N
0
12
6.50
Y
1
104
6.50
Y
2
204
6.50
N
2
206
6.50
N
1
101
7.00
Y
1
106
7.00
Y
2
201
7.00
N
1
107
7.25
Y
1
105
7.30
Y
2
205
7.30
N


Epinn

"Epinn" wrote in message
...
I am not trying to do exactly what Matt has in mind. But if my purpose
is to get a list of room numbers for the calling time and I don't have
to stick to a certain layout, I'll do the following.

Each record will have four fields.

Floor Room # Wake-up call at Newspaper (Y/N)

Then I'll do a sort by wake-up call and then by room #. I don't have to
be bothered with formulas. It will look like this:-

Floor Room #. Wake-up call at Newspaper
1 102 6.00 Y
2 202 6.00 N
2 207 6.00 N
1 103 6.25 Y
2 203 6.25 N
0 12 6.50 Y
1 104 6.50 Y
2 204 6.50 N
2 206 6.50 N
1 101 7.00 Y
1 106 7.00 Y
2 201 7.00 N
1 107 7.25 Y
1 105 7.30 Y
2 205 7.30 N


Matt's layout is going across while mine is going down. Let me give it
some more thought and see how my layout can be transformed to Matt's.

One can also hide the wake-up call column so that the newspaper column
is right beside room #. Then feel free to do a sort by newspaper
column.

All this may not serve Matt's purpose but I feel like picking my brain.