I’ve an excel sheet, like a master sheet with loads of different information in it.
But I want to create a small subset of the data into 1 spreadsheet.
ie Existing sheet is comething like:
column A,…..,Column R, Column S, …..
Client A,…..,Value 1, no1, …..
Client A,…..,Value 1, no2, …..
Client A,…..,Value 1, no2, …..
Client A,…..,Value 2, no3, …..
Client A,…..,Value 1, no1, …..
Client A,…..,Value 1, no6, …..
Client A,…..,Value 2, no4, …..
Client A,…..,Value 1, no1, …..
Client A,…..,Value 1, no8, …..
Every client will be something like that:
Now I want to turn this into:
“Column A”, “Column B”, “Column C”
“Client A,” “7 x Value 1, 2 x Value 2”, “No1, No2, No3, No6, No8(don’t want to know how many of each)”
“client B” etc etc
“client C” etc etc
etc
etc
Any excel voodoo witch doctors got a quick way of doing this? i’ve got 5000 rows, dont fancy doing this manually! 😆
Help would be much appreciated! (excel 2003)