So you want all the data from column A putting in single row? if thats
the case why not copy the data then right clickPASTE SPECIAL check
Transpose then ok, all your data should now be in one row. Or does your
organisation change every 15th row, if this is the case i will construct
some code for you later this evening as i don't have time now.
Makelei;308811 Wrote:
Hi,
Actually I want just to copy the organization info to I-column.
The structure is now
A-column I-column
Org1
Org2 (starts)
Fred - Org2
Smith - Org2
Wed
Org2 (ends)
Org3 (starts)
Jane
Smith - Org3
Thur - Org3
Org3 (ends)
Mike - Org1
Tom - Org1
Org1 (ends)
Thanks
Makelei
"Simon Lloyd" wrote:
So if i understand you right, you want to break that data out of one
column in to seperate columns but keeping the structure something
like
this
Code:
--------------------
A B C D E F..............
Org1 John Smith Tue
Org2 Fred Smith Wed
Org3 Jane Smith Thur
--------------------
*How to get further help with a workbook*
For further help with it why not join our forums (shown in
the link below) it's completely free, if you do join you will have
the
opportunity to add attachmnets to your posts so you can add workbooks
to
better illustrate your problems and get help directly with them. Also
if
you do join please post in this thread (link found below) so that
people
who have been following or helping with this query can continue to do
so. :)
Makelei;308750 Wrote:
Sorry, that it is not clear...
All data is in column A.
When new organization starts there is name of the organization.
Same
when
organization ends. Organization hierarcy is 5 levels. This means
that
the
first organization level starts at row 1 and ends to the last used
row.
Between these there is a list of organizations as level 2 to level
5.
In the middle of these two organization (start and end) rows there
is a
list
of people belonging to this organization.
Now I should get the organization information to same row to column
I.
The
problem is that when one organization ends there might be names
that
are
belonging to mother/higher organization hiearchy, which starting
row
was
before this ending organization started (and also ended).
Hopefully this clarifies a bit ;o)
Makelei
"Simon Lloyd" wrote:
I can't make out what you're query is, how is your data laid out
in
columns? what is it that you would like to achieve?Makelei;308728
Wrote:
Hi,
I need some help with looping....
Using Excel 2003.
I have a list of some 30 000 rows. It has organization and
person
information in following way:
Org1
Org2 (starting - just name of it)
Name2-1
Name2-2
...
Name2-N
Org2 (ending - just the name of it)
Org3 (starting - just name of it)
Name3-1
...
Name3-N
Org3 (ending - just the name of it)
Name1-1 (belongin to Org1)
....
Name1-N (belongin to Org1)
Org1 (ending - just the name of it)
I need to get the Org-name next to name column. I am not quite
sure
how
to
make it in a way that it will check starting and ending and
when
ending
there
might be person belongin to previous organization...
I have been able to get so far that it is filling up allrigtm,
but
when
ending and earlier organization should be returned, I cannot
figure
out
how.
Oranization hierarchy is 5 levels.
Any help would be appreciated
Makelei
--
Simon Lloyd
Regards,
Simn Lloyd
'The Code Cage' ('The Code Cage' ('The Code Cage'
(http://www.thecodecage.com/)))
------------------------------------------------------------------------
Simon Lloyd's Profile: 'The Code Cage Forums - View Profile:
Simon
Lloyd' ('The Code Cage Forums - View Profile: Simon Lloyd'
(http://www.thecodecage.com/forumz/member.php?userid=1))
View this thread: 'Looping help needed - The Code Cage Forums'
('Looping help needed - The Code Cage Forums'
(http://www.thecodecage.com/forumz/sh...d.php?t=86323))
--
Simon Lloyd
Regards,
Simon Lloyd
'The Code Cage' ('The Code Cage' (http://www.thecodecage.com))
------------------------------------------------------------------------
Simon Lloyd's Profile: 'The Code Cage Forums - View Profile: Simon
Lloyd' (http://www.thecodecage.com/forumz/member.php?userid=1)
View this thread: 'Looping help needed - The Code Cage Forums'
(http://www.thecodecage.com/forumz/sh...ad.php?t=86323)
--
Simon Lloyd
Regards,
Simon Lloyd
'The Code Cage' (
http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile:
http://www.thecodecage.com/forumz/member.php?userid=1
View this thread:
http://www.thecodecage.com/forumz/sh...ad.php?t=86323