I am trying to rearrange data in Calc to suit the needs for further processing in Calc.
My understanding of Calc and macros tells me it should be possible to create such a macro. However my knowledge of writing Calc macros is too little to challenge such a macro. With this post, a cry for help, I hope that one of the Calc macro freaks around here will help me with the needed macro.
The macro needs to identify certain cells and then move the cells into a different position, add 5 neighboring cells and delete 5 neighboring cells.
This needs to be done several times until the end to the data range. The number of rows between the cells, which needs to moved, are at random.
In the attached Calc file all is made visible.
Columns A, B, C, D, E, F contain the data as they are taken from a pdf-File and pasted into Calc in position A1.
Columns H, I, J, K. L contain the data as they need to arranged by the macro.
In the columns B, C, D (original data) there are yellow and green marked cells. These cells need to be moved into the position shown in columns I, J. K, L.
The dark blue cells need to added that below cells are moved down.
The orange marked cells need to deleted that the below cells move up.
It can be seen that with this macro the original data arrangement will be made into a consistentFileForHelpOnMacro_LibOSupport.ods pattern from the top of the data range until its end.
I think it will not matter, but I am using LibO 5.4 on Linux Mint 17.3 KDE (still my workhorse; both versions are ancient, I know) but the new PC is under installation with Linux Mint 19.3 Cinnamon and the latest LibO version will be installed. Thus, if needed LibO 6.x can be used.
I do appreciate your help in this matter very much.