Row to column

[tonyradstone]

I have a list of mooring places on the Burgundy canal in France , I wish to move the data from rows to columns . Some entries will have rows missing when there is no data such as the ratings.

So I would like a columns headed Name ,Lat/Long,reference etc and the data moved

Any help please

Sample file attached

[alansidman]

Try this:

Please Login or Register  to view this content.

A couple of changes I would suggest your your current data. You have used in some cases two cells one above the other for information. ie.B6 and B7. Make sure all the data is in one cell or it will not transfer properly. Put the data from B7 into the end of B6. There are several places that you need to do this.



How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:

1. Press Alt-F8 to open the macro list
2. Select a macro in the list
3. Click the Run button

[AB33]

Another option, but I had to delete empty row 210 for the code to work in lines.

[AB33]

A different code.
The code works by matching the headings in sheet 2 with columns 1 of sheet1, so all you need is to update the headings in row 1 of sheet2 and click the button on sheet1