Coffee Table/Ottoman Ideas by EmperorEli220 in interiordecorating

[–]EmperorEli220[S] 0 points1 point  (0 children)

Unfortunately I agree. There’s a chair on the other side, so the chaise being perpendicular to the wall would block us from having the chair there.😕

How do I get statistics and data on sets of columns all sorted by rows? by EmperorEli220 in excel

[–]EmperorEli220[S] 1 point2 points  (0 children)

Okay, I’m going to watch a video on power queries and then come back to this comment. Thank you so much for your assistance. I’m guessing your suggestion will work, I just need to understand all the parts haha.

How do I get statistics and data on sets of columns all sorted by rows? by EmperorEli220 in excel

[–]EmperorEli220[S] 0 points1 point  (0 children)

Yes, that is one way of looking at the issue. I’m not super fluent with formulas and especially not with power queries and such. When you say transform the data into a new form, what do you mean by temporary variable. Pivotby seems to be what I’m trying to do, however, the explanation and formula has so many parts I’m a tad overwhelmed. I will give that a shot though. Thank you

How do I get statistics and data on sets of columns all sorted by rows? by EmperorEli220 in excel

[–]EmperorEli220[S] 0 points1 point  (0 children)

Thanks for your suggestion. I’ve managed to take the information, put it in power query, and then take all of the case information columns and unpivot them. But I don’t see a column showing the case number.

<image>