Hi, I have this data in Excel sheet Name John Phone 123 E-mail john@hotmail.com Name Jason Phone 234 E-mail jason@hotmail.com How can I rearrange it to be? John 123 john@hotmail.com Jason 234 jason@hotmail.com Thanks, John

Let's say A1 contains Name and B1 John. Insert a row into ROW 1 or above your date placing column headings for each field of data. (Name, Phone, Email) In B2 use =A2 In C2 use =A3 In D2 use =A4 Now do the same next to Jason In B5 use =A5 In C5 use =A6 In D5 use =A7 Now select all cells from B2:D7 Place your cursor over the bottom right hand corner of D7 so that the cursor changes to the crosshairs, Then click and drag it down your column (or double click on it to make it copy down the column.) Now click and drag on the column B thru D to select all data in those columns. Right click on one of the selected cells and select Copy. Right click again and select Paste, Special, Values. Now, delete column A. Now select all of your data by selecting B2 and hitting Shift+End. Go to Data, Sort, by Name (which is column A now) Now, you should have what you asked for. To complete the exercise you'll want remove all of the blank rows to keep your speadsheet smaller in size so now... Click in A2 and then hold the Ctrl key and then hit the Down Arrow key to get to the last cell in your sheet that contains data. Without any other keys hit the down arrow one time to get to the first cell tha thas no data below your data. Now hold Shift and hit the End key, release and then hit the Delete key to get rid of the blank cells. Save your spreadsheet. Was that clear enough? HTH Bryan

You were not too specific but if you have headings for name, email, and phone with the data below in columns, and are simply trying to combine the contents of 3 cells into 1 cell, you could just use a formula such as: =A1&" "&B1&" "&C1 Or is my thinking off here?

Oops. Let's say A1 contains Name and B1 John. Delete column A Insert a row into ROW 1 or above your data placing column headings for each field of data. (Name, Phone, Email) In B2 use =A2 In C2 use =A3 In D2 use =A4 Now do the same next to Jason In B5 use =A5 In C5 use =A6 In D5 use =A7 Now select all cells from B2:D7 Place your cursor over the bottom right hand corner of D7 so that the cursor changes to the crosshairs, Then click and drag it down your column (or double click on it to make it copy down the column.) Now click and drag on the column B thru D to select all data in those columns. Right click on one of the selected cells and select Copy. Right click again and select Paste, Special, Values. Now, delete column A. Now select all of your data by selecting B2 and hitting Shift+End. Go to Data, Sort, by Name (which is column A now) Now, you should have what you asked for. To complete the exercise you'll want remove all of the blank rows to keep your speadsheet smaller in size so now... Click in A2 and then hold the Ctrl key and then hit the Down Arrow key to get to the last cell in your sheet that contains data. Without any other keys hit the down arrow one time to get to the first cell tha thas no data below your data. Now hold Shift and hit the End key, release and then hit the Delete key to get rid of the blank cells. Save your spreadsheet. Was that clear enough? HTH Bryan