Data → Pivot Table → Create → Current Selection → OK.

Select the the first cell of data on the first sheet. Create a second sheet, called PivotTable, to hold a pivot table (called Data Pilot in older releases of Open Office).

After that, start again by locating the next cell that has data in it and repeat the transposing.Add three helper columns to the data, as shown on the attachment. So if it could be done, the instruction to the software would be to copy/move/transpose the data until an empty row is encountered and then stop. NoCombovers wrote:There is always an empty row (or 2) after the last piece of data from one company and before the first row of data of the next company. The company name and address fields don't look like they will need any/much work. some email addresses will be where phone numbers should go, fax numbers instead of email addresses, etc., etc.), plus all the other things I already mentioned. I know I will have to do some clean up after this automation has been completed because some of the data will be in the wrong fields (e.g. It would not matter if there were any empty rows in the finished spreadsheet as sorting would get rid of them. So if it could be done, the instruction to the software would be to copy/move/transpose the data until an empty row is encountered and then stop.Īfter that, start again by locating the next cell that has data in it and repeat the transposing. There is always an empty row (or 2) after the last piece of data from one company and before the first row of data of the next company. I want the software to transfer all the data, which is currently laid out in 'box form' all in one column and in a small number of rows (6-9 or so) and put the data into a single row as is the normal way of showing data in a record. Villeroy wrote:You want to transpose some (5? 8? 12? variable?) row sets into one row per set and write the resulting rows into a list. I can't follow the tutorial because it uses language that I do not understand. I don't know what software was used to create the data (the data comes from unknown websites) or what software is appropriate for this task. If it has to be converted for some reason, this excellent tutorial with document is made for you: Rearrange rectangular data values Simply use the appropriate software for the existing data layout. Your data have been written by some software to be used by some software. You want to transpose some (5? 8? 12? variable?) row sets into one row per set and write the resulting rows into a list. You want to re-arrange them in a much more complicated fashion. of 1024 columns and you do not want to transpose all the 10,000 rows anyway. Transposing 1 column of 10,000 rows results in one row of 10,000 columns.

Transpose function neooffice