Untitled.jpg
From sheet1. There are 2 sets of data with 2 types I want them to appear in sheet2 like in the picture.
In sheet2,column A shows Types and column B shows Sum of each type.
And most important is to begin a new row when there are more data types in sheet1, like Data 1 c and Data 2 d, so it adds more rows for Type c and Type d.
Can it be done and can you teach me please? Thank you
Edit: The type of data indicates by last letter in Sheet1 column A(a,b,c,d..). Don't know if this helps.
Edit2: Typo
PS. I think I did post in the wrong forum before so I didn't get any reply there.
Bookmarks