Convert the Column containing data to Columns using "text to columns" - with space as a delimiter.
Delete the first column after the event, then re-concatenate format like B1&C1&D1 [and so on down the column] afterwards, copy it onto itself as "Values" and delete the working columns.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.