Lupp, I think the example you posted is what I need. Your example shows Column A which I call the source and it shows the array/ranges which I call “sets” grouped together then transposed to Columns H through N. I don’t need my results to show Columns C through G including the Helpers which I don’t know what they are).
How do I implement this to my workbook spreadsheet to reflect upon 20,000+ rows of data in Column A which contains many sets grouped together? Thank you very much!
I copied my Column A into your ask68180ComplicatedRearrangement001.ods and it works! 
but it only does it for 23 rows 
I guess those Helper columns you added actually do something
Is there a way to make this work for 20,000+ rows? since i will be given more data on spreadsheets like this in the future, a rearrangement with more or less rows to insert my source column and specify the amount of rows needed or make it infinite which would be preferred method so dont have to do it manually
Would it help if I found out exactly how many rows my source Column A has in this project? Thank you for all your help!
I know it may seem as though transposing this data would not help but to a noob it really does for comparison sorting and aesthetics on screen. I’m sure more advanced users have skills to do this and much more but I just need it so I can eventually sort the results in columns as needed. You are a big help and very much appreciated
Well organised data should not require such a lot of processing to prepare a ‘PrettyPrint’. In your case a better concept of keeping your data should mainly require two additional measures
Due to the length of the sections not being constant, the task will still be nontrivial in a sense.
i posted another question if there is a way to remove all empty rows except for one. then maybe i could find a macro or someone what could make a formula that transposes/moves every block of linear/contiguous set of grouped data to the new columns.
I’m was hoping for the easiest quickest solution. i don’t even need to keep formatting or cell equations just the alphanumeric characters, numbers & symbols in the cells.
i would like to know how to do this myself if possible too. any videos? ty
the way i received the data is bad i know it’s horribly organized which makes it impossible to compare and sort unless the rows are transposed to like/similar columns for sorting purposes.
i thought there may be some quick easy macro script i could run that would crawl the columns transposing all contiguous/linear grouped data sets, ignore any/all blank/empty rows then to loop and keep repeating itself until it intelligently finds no more data in source column OR reached spreadsheet maximum row limit OR certain amount of empty rows OR specified amount of rows
I am going to use your instructions and step by step write how I follow them
1. Fill in your 1-column-data into column A of sheet ‘Solution’ beginning with A2.
If my data starts at A1 (w/o without a single header row) the last filled cell entry ends at A25959.
If it starts at A2 (with a single header row) then the last filled cell entry ends at A25960
I left clicked on A2 to select the cell then scrolled down using the scroll bars and shift left clicked on cell A25960
Copied, Pasted
Do I continue where you left off and Left Click in C207 then drag right to cell F207 or G207?
OR
Do I start with a Left Click in C2 then drag right to F2 or G2?
THEN
from which cell do I drag down all the way until row 25960?
thank you
step 1 done
step 2 copied from C to F all the way down to the last line in Column A, i noticed lowercase “a” (without the “quotes”) in Cell didn’t include Column G14 to G207 but did not include Column G while dragging the Helper columns (C through F) all the way down to Row 25960.
Step 3 I don’t know what cell I’m starting from…I keep getting a popup that says
“You cannot change only part of an array.”
am i missing a step and supposed to be doing something with Column G and/or R (GENERATOR_GROUPS) because from what I’ve tried isn’t working.
I’m using a mac so when i press Control a popup appears so I guess it would be Command button.
Anyways, E25 and all the way down says #N/A
maybe something broke, I can’t alter anything in the Array (purple cells)
should’ve i done the helpers first then put my data in so the array cells would recognize it, im lost. is there an animated help gif or video?
I’ve tried various of things and still nothing is working either because I’m doing something wrong or not quite understanding the steps exactly as I need to do. If there was a video somewhere would probably solve this immediately but I’ve googled and checked youtube and came out short on a solution.
It won’t let me change anything, don’t know where to start. Some cells managed to fill with something Err:508. Am I supposed to delete everything in the purple box? Thank you
Thank you Lupp unfortunately the ask68180ComplicatedRearrangement001.ods engine does not work further than line 23 then stops. This may be due to Column A adjacent cells changing (there is no define pattern that i saw such as 6 rows of adjacent data 4 rows of empty rows 7 rows of adjacent data then 2 rows of empty rows and repeating until the column is exhausted of entries. I’ve tried several ways to edit the engine, without knowing where to start it’s a dead end.
I tried to follow the instructions you gave as well as I could comprehend and also tried various others methods. I didn’t think that this should be so difficult but I guess it is as this answer is only partially correct and no one else has commented. It’s disappointing that spreadsheet software these days isn’t intelligent enough to rearrange data with a couple of clicks. Maybe I’m using the wrong program but I thought Calc would be able to do this in a blink of an eye. Thanks for trying
This topic remains partially answered to anyone that would like to contribute, it’s much appreciated, hopefully programmers take input in forums and integrate it right away with new versions however with spreadsheet software being around for decades it seems as though it’s direction may be more focused on design than implementation. Spreadsheets should be able to do more advanced functions with sorting, filtering and rearranging data out of the box than just it’s basic operations and functions.
This topic remains partially answered to anyone that would like to contribute, it’s much appreciated, hopefully programmers take input in forums and integrate it right away with new versions however with spreadsheet software being around for decades it seems as though it’s direction may be more focused on design than implementation. Spreadsheets should be able to do more advanced functions with sorting, filtering and rearranging data out of the box than just it’s basic operations and functions.
SIDE NOTE Where is the checkbox to signup to email alerts when a new comment is added so one doesn’t have to open bookmarks to find this post. i dont need “subscribe to rss feed” i need to get an email that someone posted. thank you