Count value in column

You have an Excel table with 6 columns for genres, and you want to count how many times each unique genre appears across all columns. The output should look like:

Genre    Count
Action    45
Romance    30
Comedy    25

Solution in Excel
Combine all genre columns into one column
Suppose your genres are in columns B:G.
Copy all 6 columns and paste them below each other into a single helper column (say column H).
Now you have one long list of all genres.
Remove blanks (if any).
Insert PivotTable
Select the helper column (H).
Go to Insert → PivotTable.
Drag Genre into Rows.
Drag Genre again into Values → change to Count.
✅ This will give you a unique list of genres with their counts.
⚡ Formula Alternative (without PivotTable)

If your data is in B2:G100:

Put this formula in H2 (spill formula for Excel 365+):→ Joins all 6 genres into one cell separated by commas.

=TEXTJOIN(",",TRUE,B2:G2)

Then use Power Query or split the joined data into rows (Data → Split Column → By Delimiter → Expand rows).
Finally, count genres with PivotTable or COUNTIF.