[SOLVED]Looking for Formula to sort My data

Kindly Refer the Attachment to properly understand the problem.

i want to fill all the Empty cells ( in both 'Sector' and 'Dept Date' Columns ) using some formula.

Have tried 'Vlookup' which is a failure , Hence at the Moment i am simply Copy-Pasting the 'Data' which is in very first cell above the Empty Cells.
and its the only way at the moment which gives me correct data,but for sorting Huge data of thousands of Rows its very cumbersome and time consuming.
Hence am looking for some formula which could be of help in getting me the same data which is in the sheet named 'Final Data Must be like This'

Hope some body could assist me with the same.

'Custom' sort is of no help here in my instance as there are other factors like 'Total count of PNR' is also included . if i do 'custom sort' then PNRs are getting Repeated even if they are on the same sector.

Thanks & Regards

yes , i have sorted the data to show that final data must appear like this after the formula is applied on sheet 2 ,
can we custom sort the 'raw data' to appear as it is in ' Final Data ... ' ?
actually i need a formula to apply in similar scenarios.

after applying Pivot on raw data i get the Sheet 2.
there are atleast 26 columns in Raw Data when we retrieve the data from server.
here i have just given a brief example of actual data.

i think i am not able to properly put the question here in the given example.
the thing is that i need to lookup the pivoted data and get same result as is in "Final data..."

Vlook up fails because it repeats the same thing which it fetches in its first lookup.

ok buddy ,thanks for the answer

'Custom' sort is of no help here in my instance as there are other factors like 'count of PNR' is also included . if i do 'custom sort' then PNRs are getting Repeated even if they are for the same sector and same date.

Originally Posted by JohnTopley

O.K - I 'm sure you'll come back if you need further assistance. The number of columns is immaterial with regard to the sort so (as I understand your requirement) sort is still an option.

I see little point in the Pivot if you then need to "reformat" to get the final result.

'Custom' sort is of no help here in my instance as there are other factors like 'Total count of PNR' is also included . if i do 'custom sort' then PNRs are getting Repeated even if they are for the same sector and same date.

Without Pivot we wont be able to get the Final Data as it must be.

kindly Check the new attachment to get my point .

See Sheet "SUMMARY"

Copy first row of "Sheet2" to row 2 of "SUMMARY"

in A3 of "SUMMARY"

=IF(Sheet2!A3<>"",Sheet2!A3,Summary!A2)

in B3 of SUMMARY

=IF(Sheet2!B3<>"",Sheet2!B3,Summary!B2)

in C3

=Sheet2!C3

in D3

=Sheet2!D3


Copy down