I own an excel sheet which list the different SAP modules used by a user. The problem is that adjectives modules are placed surrounded by columns and an "x" indicates whether the member of staff have access. When an hand have access to more modules, this generate different lines in my excel report. I would resembling to combine those lines (so that you see in one line adjectives modules the hand have access to).
Answers: A Q&D method to try, would be to use a pivot table.
This is assuming that you hold the name contained by column A, the first modules within column B, the second modules within column C etc.
Example:
Name ... mod1 . mod2
Bob .. ..X
Charlie ... .X
Dave... X
Eric .. X
Bob... X
This would produce a pivot table
Name ...Count of Mod1 ...Count of Mod2
bob...1. 1
charlie.1
dave....1
Eric.... 1
Grand Total.3... 2
Excuse dots but be merely passageway to obtain the layout displayed contained by Yahoo
I'm have trouble visualize the layout of your spreadsheet, but my best guess at this point would be a combination of if statements.
=trim( if(column have an X, "columnname","")&" "&if(another column have an X, "columnname","")&" "& etc )
The trim is freshly to promise beside influential spaces you may grasp because the first column may not be used by a singular user.