Reverse Transpose

sfsdfdf.JPG

Can someone please tell me how to get this result in reverse. As in from M1:S1

=TRANSPOSE(FILTER(K1:K20,L1:L20="Even",SORTBY(K1:K20,A1:A20,-1)))

Your description just gives a different location for the output, which doesn't illustrate anything in reverse. Please attach your actual Excel file, and explain what you mean by "in reverse". Show an example of what result you want.

Sorry. Took me a while to figure attachments out in pc version

Please read the yellow banner at the top of this page on how to attach a file.


Hi and welcome to the forum

Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc. Additionally, due to how some browsers behave, many of our members cannot see uploaded pictures/images. Please do not take this route.

Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Originally Posted by alansidman

Please read the yellow banner at the top of this page on how to attach a file.

Yes, Sorry. I edited the previous post and attached the sheet

The screen shot you showed does not appear in your file, and row 1 has other data so you can't put a spill formula there. The spill formulas you do have in column N don't match the screenshot. Can you reconcile what your actual file has with what you want it to look like?

You can take your formula and change the sort order to put the numbers in reverse of what you are showing:

Formula:

Please Login or Register  to view this content.

However, you can't make it spill to the right. You have to put the formula in the leftmost cell where you want the spill range to start.