Hello all,
I'm having trouble with data. I have a large output that I initially used a Macro to transpose every n rows to a column. Long story short, that didn't work for the output. So I'm trying to find a way to transpose a single row into columns based on the a common value. This is an example of what I have:
What I would like to do is transpose to a new row every time the text contains "Number:" for something like this:
Any help would be greatly appeciated
I'm having trouble with data. I have a large output that I initially used a Macro to transpose every n rows to a column. Long story short, that didn't work for the output. So I'm trying to find a way to transpose a single row into columns based on the a common value. This is an example of what I have:
What I would like to do is transpose to a new row every time the text contains "Number:" for something like this:
Any help would be greatly appeciated