As pointed out by Jorge in a previous answer, there are a wide diversity of ways to achieve what you are looking for. My favorites are spidifying and stacking chips.
The first alternative cannot be done directly within CARTO Editor, you have to use CARTO.js and
Markercluster Leaflet's plugin. Here you have a working example. However, the second method can be implemented just using SQL:
WITH m AS (
GROUP BY the_geom_webmercator
ORDER BY y DESC
f AS (
generate_series(1, array_length(id_list,1)) p,
ST_Translate(f.the_geom_webmercator,0,f.p*50) as the_geom_webmercator,
FROM f, table_name q
WHERE f.cartodb_id = q.cartodb_id
You only need to replace
table_name with your dataset name and add in the last
SELECT the fields you are interested in like this
q.field2 and so on. In addition, depending on your zoom range you should change the offset parameter (in my case I have used
50). Here you have a working example.