Count matching columns, give total, compress into 1 line that you can click to open

My ex-wife showed me how to do this once years ago but I cannot remember how to do it for the life of me after that one time. I don't use Excel, I normally just fix it when it breaks! (IT Support Engineer)

My customer asked me for a list of applications installed on all computers at their company, which there is a sampling of below. Column A is the machine name, Column B is the application. She was able to show me how to take the whole sheet, and make it so every column B that had the same value, it would take them all and compress them down into 1 column with a + sign to the left of it, and a total of the # of columns that had that match on the right (ie.. it would say 5 for 7-Zip 9.20 in my sample). Then you could click on the + sign and it would expand all of the columns and you could see all 5 of the machines it was installed on, then click the - and it would compress them back down to 1 column. That way I would have only 1 column for each program, a total of how many have that program, and can expand out to see all of the lines if needed.

Can anyone help me with that? I would appreciate it and help you fix any PC problems you have






Capture.PNG

You're right about the formatting... The forum ruins it. So...Will you please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).

1. Make sure that your sample data are truly REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution is also shown (mock up the results manually).

3. Make sure that all confidential information is removed first!!

4. Try to avoid using merged cells. They cause lots of problems!

Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Originally Posted by LVetula

Except can column H then display how many columns there are inside each item

sorry, I don't understand
there are only two columns

if you want to count something, drag from the top item or item2 to VALUES field

or attach example to show what you want to achieve

if she can do it so do it