How to remove blank cells

[Bren1987]

hey guys i have a sheet with merged cells.

my trouble is when i copy the data in merged cells to another sheet i get a blank cell next to the cell with data. this is all macro controlled so i need to be able to move this data in a macro and have blank cells removed.

any ideas how? as i need this data to create pivot tables. so merging the cells on the sheet it is pasted to will not allow a pivot table to be created.

Bren

[oeldere]

You give already the perfect answer.

Don't use merged cells (and if you have them, remove them).

[Bren1987]

thanks dude. just thought there might have been a way. i have managed to rearrange it to do what is needed.

[Cutter]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save