Google spreadsheet (Excel) - how to make statistics on the contents of a column?

Question

excel

There is a document:
https://docs.google.com/spreadsheets/d/1aWt-Ey6MVI...
I need to get from column A into columns:
a) all possible unique brands (sort alphabetically)
b) all possible colors (very it is desirable to combine different languages ​​into one) (sort alphabetically)
c) type of shoes (it is desirable to combine different languages ​​into one value) (sort alphabetically)
d) brand + type of shoes (if possible)
I managed to do this:
a) manually split a cell into different columns ("split into columns" function), so that each word/character is in a separate column
b) in the resulting columns took out unique values ​​in cells (Unique), different languages ​​in a separate line
c) took out the number of these words/values
However, I want to automate the process + be able to see the "brand + type of shoes", in order to understand what exactly was sold by this brand.
Thank you!

Answer 1

Option:
1. Create 2 separate sheets "Aggregator" and "Sales"
2. On the sheet "Sales" we keep your column A
3. On the sheet "Aggregator" a table of the format is created: Product name (A) | Brand(B) | Type(C) | Color(D) | Size(E) | Sold (F)
Where:
a) Product name - a unique list of products (your column A of the "Sales" sheet but without duplicates)
b) columns from Brand to Size are entered according to the specific name of the Product
c) Sold - Write the formula in cell F1 (I write Excel I think you can adapt the tables to Google) = COUNTIF (Sales! A: A; Aggregator! A1)
4. Based on the "Aggregator" sheet, make pivot tables in any sections you need