Sorting Organisation Data?

sungod1205

New Member
Joined
Mar 19, 2018
Messages
1
Hello all, what a wonderful place this is...loads to learn here, just need a bit more time to browse the posts.

In the mean time, I have a question to pose of my own, it has so far caused me to waste a huge amount of time, and effort...and I have got nowhere.

I hope you may be able to help.


I am trying to organise my organisations personnel data.

The data I am using has only has 5 columns (for ease in the org chart I hope to make later).

Post Reference - an 8 digit number stored as text (as many start '00......).
Employee Name - Text string.
Post Title - Text String.
Reports To Ref - an 8 digit number (again stored as text for the same reason) - these match against existing Post Ref's.
Location - Text String.

I am trying to organise my data within the spreadsheet so that it flows down in line management chains. :confused:
Like the example below...at the moment it is sorted numerically (for all 2900 posts) by the Post Ref Nos.
I have emboldened the CEO and two department heads below to indicate different departments.

Post RefNAMEPOST TITLEREPORTS-TOLOCATION
00104025FredCEO00212343London
00204022JeffDeputy Head00104025London
00213193PeteAH Field00204022London
00204023JennyChief Operating Officer00104025Reading
00204021GemmaCOO Change Mgmt00204023Reading
00211020MikeCOO Change Officer00204021Reading
00222468PaulCOO Project Mgmt00204023Reading
00222469DirkCOO Finance Mgmt00204023Reading
00209378LizCOO Finance Officer00222469Reading
00222470BevCOO Operations Mgmt00204023Reading
00218527BenCOO Operations Officer00222470Reading
00215849TraceyHead of People00104025London
00104368TinaHR Manager 100215849London
00104368aTonyHR Manager 200215849London
00205730RichardHR Manager 300215849London
00210518RobHR Manager 400215849London
00216739RachelHR Manager 500215849London
00104209JulieHR Advisor 100216739London
00104234VictoriaHR Advisor 200216739London
00109959JacquiHR Advisor 300216739London
00217861JeremyHR Advisor 400216739London

<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>

Any help VERY gratefully received - at the moment I am manually copying rows from one sheet to another after searching the filtered 'reports-to' column...slow and incredibly painful!!!


Very Many Thanks in Advance.
 

Dryver14

Well-known Member
Joined
Mar 22, 2010
Messages
2,396
Not sure how we can help with this.

We would need at least to see a section of the unfiltered data (fictional or otherwise) to see if the process could be automated or if we can advise on quicker sorting and filtering methods
 

Forum statistics

Threads
1,086,138
Messages
5,388,070
Members
402,100
Latest member
Rizwan ul haq

Some videos you may like

This Week's Hot Topics

Top