SOLVED

Can I transpose unique formula spill direction?

Copper Contributor

Can I transpose the unique formula spill direction from vertical to horizontal (left to right)? I have a pivot table and I'd like to include the unique values for each unique ID value in the pivot table rows.

3 Replies
best response confirmed by SergeiBaklan (MVP)
Solution
If I understand your goal correctly (and you're using 365), you can use the TOROW function.
Thanks, that worked!
You're welcome!
1 best response

Accepted Solutions
best response confirmed by SergeiBaklan (MVP)
Solution
If I understand your goal correctly (and you're using 365), you can use the TOROW function.

View solution in original post