I would like to merge together two columns in Tableau which have similar values in order to get a bar graph that showcases the count of each value, while still maintaining the original values. I can not post workbok due to sensitivities, apologies. Sample data below.

Example data:

COLUMN1

Red

Red

Red

Orange

Blue

Green

COLUMN 2

Red

Blue

Blue

Orange

Green

DESIRED OUTPUT:

Red Count:4

Orange Count: 2

Blue Count: 3

Green Count:2

And represented as bar graph. Basically summing the occurrence of the values across two similar columns. I tried merge, but then i lose the original COLUMN 1 and COLUMN2 which I need. Hope this makes sense.