Hi
ChatGPT is a language model trained on common language occurrences. Knowing that I have to wonder if what you are trying to achieve would be less common in the text given the superiority of spreadsheets or code for what you are trying to achieve.
Thinking along that line I then think 2 things.
- It is unlikely that this is the type of text problem it would encounter.
- You would do best to use code rather than a large language model to solve this.
IMHO
Good luck 