How to compress a table into a simpler table?

Jimi Sherman
Jimi Sherman used Ask the Experts™
on
I have a column of info that needs to be compressed into a simpler table.
I have attached an example.
A macro would be perfect for what I am trying to do.
Thanks
Jimi
Change-Table--Example.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Try this sample (Press Go button)
Change-Table--Example.xlsm

Author

Commented:
That works PERFECT!!
Thank you.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial