troubleshooting Question

GroupBy Table

Avatar of tonelm54
tonelm54 asked on
1 Comment1 Solution7 ViewsLast Modified:
I've no idea how to even start this, so I need help :-S

I have a table consisting of several columns, and the first 3 I want to group by and merge the rows if the content above is the same. I can loop through all the rows of the table and test the row above but if the group of rows is 3 or 4 I don't know how to detect and move to the row above.

For example, if I have a table like:-
What I need is to format it to:-Then to add insult to injury, I need to be able to search, which Ive done before by filtering through and hiding and showing rows with the data in, but once I start to merge rows Ive no idea how I can do this.

Can anyone help me with trying to figure out where to start on this issue, as I dont even know where to start on this

Thank you in advance

Senior Developer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros