If someone could advise me on an efficient way to do this I would appreciate
it.
I have a sheet that shows the amount of time(col A) a machine is in mode
(40, A0, 22, B0...)(col B). These columns cannot be sorted in the sheet that
it's on. It's set up similar to this:
A B
1 6:00 40
2 3:00 A0
3 2:00 22
4 5:00 40
5 1:00 B0
6 4:00 A0

I would like a second sheet that would display all of the machine codes in
seperate columns like this:
A B C D E
1 downtime code 22 A0 40 B0
2 2:00 3:00 6:00 1:00
3 4:00 5:00

So each time would be listed in a column for that particular downtime code.