Flip row and columns

TVP ALAN

When create a form with a lot of questions the sheet will be very large ?

Do we have the possibility to flip the questions and the answers…. so the sheet will be more easy to read ..

Brgds

alan

Brian_Richardson

Not without a lot of work. Sorry Alan.

If you need to flip the rows and columns, see my post on how to setup an Unpivot.

CHALLENGE: Unpivot financial data (reverse pivot)

Brian_Richardson

Dec 12, 2022

I have a challenge for this awesome community.... has anyone successfully found a way to unpivot data? I need to take columnar data ($ per month with each month in a column) to become row data (each project and month on a row).

I need to do this in order to mesh user-entered horizontal forecasts, with Oracle-sourced vertical actuals. I do realize I could pivot the Oracle vertical data and then run some comparisons, but I feel like there's a more elegant way to do this that wouldn't rely on hard-coding months or other pieces. I can think of other use cases for this, like a timecard entry for example.

Starting Data

https://us.v-cdn.net/6031209/uploads/VPO2LQWDI3DZ/image.png

The GOAL!

https://us.v-cdn.net/6031209/uploads/NL3LSCKYXOOF/image.png

---

View Post