get data in a new column from first column with value

[sxmajmda]

When I get a report out of the system, “column a” should have all the names, instead it is first few rows name is in “column a”, then it is in “column b” then in “column c” and so on….
So I want to add a column before “column a” and in the “new column a” I want to get data from all the other columns…hope it makes sense…

Name			Age
John			30
James			32
Mary			28
Aaron			31
	Bill		26
	Joe			34
	Pete				37
		Ashley			32
		Nolan			26

<tbody>
</tbody>

So once I add the new columns it should appear something like this

Name	Age	Name			Age
John	30	John			30
James	32	James			32
Mary	28	Mary			28
Aaron	31	Aaron			31
Bill	26		Bill		26
Joe	34		Joe			34
Pete	37		Pete				37
Ashley	32			Ashley			32
Nolan	26			Nolan			26

<tbody>
</tbody>

Can anyone help me with this?

 

[ExcelTactics]

It is possible to select only the blank cells within a selection, delete them, and shift the rest of the cells over to fix data alignment. This is likely your easiest course of action. A quick tutorial is available here: How to Automatically Delete Blank Cells to Organize Data

Hope that helps!

 

[sxmajmda]

Thanks a ton...never thought of it. This is real simple.