0

I have situations such as this:

enter image description here

where between the bunch of addresses reaching the 3000th row I have the name of the town from time to time. In order to avoid scrolling thru this whole list and rewriting them, I think, that maybe Excel has some formula for extraction just these particular strings and placing them in a separate cell or list of cells. Is it possible?

Geographos
  • 133

1 Answers1

0

Alternatively, we can use the Collapse all data button for Pivot Tables

https://www.got-it.ai/solutions/excel-chat/excel-tutorial/collapse-rows-and-columns/how-to-collapse-rows-and-columns-in-excel

Click on any expandable data (pivot table) and select from the Main bar -> Data -> Outline -> Hide Detail option enter image description here

all pivot tables will be collapsed giving you the opportunity for copying the list of cities.

Geographos
  • 133