But I'm going to try my best...
So here's what I have. A huge list of data in 1 column like this
datadatadata
datadatadata
datadatadata
..................(two rows of spacing before the next 3 lines of data)
datadatadata
datadatadata
datadatadata
datadatadata
datadatadata
datadatadata
___________________
Okay, with showing you that terrible example, here's what I need to accomplish for work.
I need to get those 3 rows of data in separate columns right next to it, like this:
column1........................column2........................column3
datadatadata.................datadatadata.................datadatadata
datadatadata.................datadatadata.................datadatadata
datadatadata.................datadatadata.................datadatadata
___________________
Is this possible to do with a script or macro?
The initial row can stay if its a problem, so it could look like
column 1......................column 2.......................column 3........................column 4
datadatadata................datadatadata.................datadatadata.................datadatadata
datadatadata
datadatadata
datadatadata................datadatadata.................datadatadata.................datadatadata
datadatadata
datadatadata
Or whatever - I could just delete the whole first column afterwards.
It doesn't have to be perfect at all, I just have to get a faster way to do this than copy it in to the other rows manually, a script or macro that will do a whole sheet at once would be GREAT.
Each one of these sheets have about 1600 + rows (2 spaces in between each of the groups of data) so you can see why I haveeee to find a better way.
If someone could throw me a bone I'd be SUPER grateful - you have no idea how grateful lol.
Thanks in advance for trying,
Justin
EDIT: ADDED Attachment as requested !
Bookmarks