Transposing with formula

[onp]

Hello,
I am trying to transpose data from rows into columns and continue doing so for every row.
I have attached a sheet with no formulas hoping it will simplify understanding what I am trying to achieve.

Thank you for your help and for trying

Nino

[Bo_Ry]

Please try at
N10:S20
=IFERROR(INDEX($B:$B,AGGREGATE(15,6,ROW($A$10:$A$999)/(A$10:$A$999=$L10)/($B$10:$B$999>=0),COLUMNS($N10:N10))),)

X10:AC20
=IFERROR(INDEX($B:$B,AGGREGATE(15,6,ROW($A$10:$A$999)/(A$10:$A$999=$L10)/($B$10:$B$999<0),COLUMNS($X10:X10))),)

[jason.b75]

One of us has got this backwards, Bo

Try this array formula in A10 (needs to be array confirmed before filling down).

Please Login or Register  to view this content.

and this normal formula in B10

Please Login or Register  to view this content.

[Bo_Ry]

Jason, after reading OP again, I'm the one got it backward.

[onp]

Hello Bo,
I have downloaded and tried the formula, but it is the reverse of what I am looking for. But still Useful)

Basically the sheet calculates the results into cell L10 to AC10
and that info needs to transpose into A and B accordingly.
Example:

Before

| L10 | M | N | 0 | P | and onward | AC |
| 3/1/2019 | Blank | 1 | 2 | | | | | -1 | -2 | -3 | -4 |
| 3/2/2019 | Blank | 1 | | | | | | -1 | -2 | |

After,
in column A10 Column B10
3/1/2019 1
3/1/2019 2
3/1/2019 -1
3/1/2019 -2
3/1/2019 -3
3/1/2019 -4
3/2/2019 1
3/2/2019 -1
3/2/2019 -3

Thank you

[onp]

Hi Jason,
Hahahhah I couldnt help myself after reading the post from you to Bo and back)
Your version is correct and your formula works great)
Thank you so much Jason)
And to Bo Also thank you so much)
Made my Day
Cheers
Nino