Jyggalag
Active Member
- Joined
- Mar 8, 2021
- Messages
- 445
- Office Version
- 365
- 2019
- Platform
- Windows
Hi all,
I currently have a very messy sheet that looks like this:
Essentially, row 1 is the heading, row 2-3 is the results that I want to produce through a text to columns, and rows 24-45 are the data that I currently have.
The issue is that my cells have become messed up, so for every cell I will need to have the variable "Number" that ends with an X (see cell J2 and J3 above).
Every single cell must contain a value from the variable "Number" (column J). However, some of these cells have been split across different rows, so for example cell A38 and A39 should be in one cell that says Z,32595932Z,X,Medium,529 rather than the structure that they have now.
My question is therefore: Does anybody know of a way in which I can join all the cells together in column A? Essentially, the formula should join everything into one cell UNTIL it reaches a number with no letters, for example 503.52, after which it should go on to the next cell and join everything together in that one until it reaches another number.
I hope this makes sense, otherwise please let me know if you want to elaborate.
I can do this manually, but it would takes ages, and some sort of automated solution would be amazing!
Thank you so much everybody
Please feel free to ask questions too!
Kind regards,
Jyggalag
I currently have a very messy sheet that looks like this:
Essentially, row 1 is the heading, row 2-3 is the results that I want to produce through a text to columns, and rows 24-45 are the data that I currently have.
The issue is that my cells have become messed up, so for every cell I will need to have the variable "Number" that ends with an X (see cell J2 and J3 above).
Every single cell must contain a value from the variable "Number" (column J). However, some of these cells have been split across different rows, so for example cell A38 and A39 should be in one cell that says Z,32595932Z,X,Medium,529 rather than the structure that they have now.
My question is therefore: Does anybody know of a way in which I can join all the cells together in column A? Essentially, the formula should join everything into one cell UNTIL it reaches a number with no letters, for example 503.52, after which it should go on to the next cell and join everything together in that one until it reaches another number.
I hope this makes sense, otherwise please let me know if you want to elaborate.
I can do this manually, but it would takes ages, and some sort of automated solution would be amazing!
Thank you so much everybody
Please feel free to ask questions too!
Kind regards,
Jyggalag
