convert multiple colums into rows

[dacooper]

I would be extremely grateful if someone could look at this.

How do I convert multiple rows of data in this format:

Data1 data2 data3 name1 name2 name3

into

data1 data2 data3 name 1
data1 data2 data3 name 2
data1 data2 data3 name 3

and so on. The added complication is some rows only have one name and so I don't need additional rows for them. And some have 2 names so I need 2 rows but not 3.

Any help would be much appreciated.

 

[Mel Smith]

Hi,

I found the following in the Help file - I hope it does!

Mel

On the worksheet, do the following:
To rearrange data from columns to rows, select the cells in the columns that contain the data.
To rearrange data from rows to columns, select the cells in the rows that contain the data.
On the Home tab, in the Clipboard group, click Copy .


Keyboard shortcut To copy the selected data, you can also press CTRL+C.

Note You can only use the Copy command to rearrange the data. To complete this procedure successfully, do not use the Cut command.

On the worksheet, select the first cell of the destination rows or columns into which you want to rearrange the copied data.
Note Copy areas (copy area: The cells that you copy when you want to paste data into another location. After you copy cells, a moving border appears around them to indicate that they've been copied.) and paste areas (paste area: The target destination for data that's been cut or copied by using the Office Clipboard.) cannot overlap. Make sure that you select a cell in a paste area that falls outside of the area from which you copied the data.

On the Home tab, in the Clipboard group, click the arrow below Paste, and then click Transpose.
After the data is transposed successfully, you can delete the data in the copy area.

 

[dacooper]

Hi

Thanks for the reply. I don't think I can use that method, however, because I do not simply want to convert all of the columns into different rows. I need the first three columns to remain as columns and be paired with the data that was in columns name1, name 2 and name 3 in three new rows (if you see what I mean)

Thanks for your help though.