The gather function is incredible and really saved us on a recent project. Is there a way to go backwards? Ungather???
The inverse of Gather is Spread.
https://www.easydatatransform.com/help/1p/windows/html/spread.html