transposing data and sort it by value

Good Afternoon

I would apreciate if i could get some help tyransposing editing and sorting data in a excell. In the attached spreadsheet you will see that on sheet 1 i have data on vertical tabs under the headers order tote sector and time, i will need to pass that data to the sheet 2 in the format that i have dsigned in there.

My apolagies if i wasnt able to explain myself

Thanks in advance

PS : i had to reduce the qty of date to be able to add the spreadseet, this will use nearly 4.000 lines

Hi luis6777

Sorry about that - there was 1 line that has become changed from when I last saw the file. It now works as it should.

Regards
Alastair

Originally Posted by aydeegee

Hi luis6777

Sorry about that - there was 1 line that has become changed from when I last saw the file. It now works as it should.

Regards
Alastair

HI Alastair

Thank you for this, just one last request, is anyway that we can merge the same tote ID in one line? instead of having several lines for the same tote id due to diferent locations can we place all locations in one line

Thanks in advance
luis

Originally Posted by ChemistB

Here is a formula way to perform your task. I am assuming that the blank spaces in column 1 should be the Order Number above it?
If so, they would need to be filled in. See below.

Once that is done,
In sheet2 D4 copied across and down

=IF(COUNTIFS(Sheet1!$A$2:$A$199,$B4,Sheet1!$B$2:$B$199,$C4,Sheet1!$C$2:$C$199,D$3),D$3,"")

To fill in blanks in a column
First, select the column then F5 (Opens Goto Window)> Special>Blanks
(that should select the blank cells in column A)
Then in the formula bar, type = and hit the up arrow
Then CNTRL + ENTER
Then select column A again and Copy>Paste Special>Values

Hi ChemistB
Thank you for your reply
Could you break down the above instructions please, im not expert with excell, is it possibel to consolidate duplicate orders and tote id, so i onluy have the same order number once and the same tote id once but the several locations in one line?

Thanks in advance
luis

Hi luis

This combines the tote ID numbers.

Hope this works OK

Regards
Alastair

Originally Posted by aydeegee

Hi luis

This combines the tote ID numbers.

Hope this works OK

Regards
Alastair

Work great
thank you very much

Hi luis

Originally Posted by luis6777

Hi Alastar my apolagies just one last question / request, i have tryed your spreadsheet, and i have place all the date that i would like to sort, unfortunatly this equals to 29904 rows, is anyway that this macro can sort all this ows as at this moment is giving me error 9 subscript out of range

your help would be apreciated

Thanks
Luis

Go in to the macro (Alt+F8 / Step into) and change the "Dim Pu(5000, 3)" to "Dim Pu(30000, 3)"

It may take a little time, but should work

Regards
Alastair

Hi luis

I have now had chance to test this. I can confirm that it works well with over 32,000 rows. Did you manage tp get it to work?

Regards
Alastair