I have the following data and need a formula or script that will transpose at each change in location. I have several thousand cells in column A to search through. My data is not consistently every 5th cell. (Locations= 001, 002, 003 etc.)
Before:
<colgroup><col></colgroup><tbody>
M-G-001-A...