Group by column display in different place

Question

Post reply

Group by column display in different place

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Ray M SSC-Insane Points: 21093 More actions · Answer 1

I think I know what you want to do.

Try Right clicking on the Cell Created when you grouped ColA, and Select Insert Row --> Inside Group Above.

And then add the ColA to the cell you want.

Then Change the width of the original ColA Cell to 0 It wont actually be 0, remove Borders from that cell and or set each cell as Hidden=True

kishoremania Ten Centuries Points: 1059 More actions · Answer 2

Thanks Ray!

It worked like a charm 🙂

I stuck up with one more issue, merging cells vertically. I am not seeing this option when I select two columns vertically by right-clicking on it. I have to merge column headers (ColC and ColD) vertically in this scenario.

I really appreciate your help.

Ray M SSC-Insane Points: 21093 More actions · Answer 3

I don't see a place where it will let you do this.

Other than removing the horizontal borders in this cell I don't think it can be done.

kishoremania Ten Centuries Points: 1059 More actions · Answer 4

Thanks Ray!

So I will compromise on it, need to check with my boss 🙁