Merging Cells Macro

[Windyisle]

Hi there, I'm trying to merge multiple rows together into one row.

Here's what I have


Name | Title 1 | Author1 | | pub 1 | 2 | 0:05 |
Name | Title 1 | Author1 | | pub 1 | 2 | 0:07 |
Name | Title 2 | Author2 | | pub 1 | 2 | 0:12 |
Name | Title 2 | Author2 | | pub 1 | 2 | 0:19 |
Name | Title 2 | Author2 | | pub 1 | 2 | 0:05 |

Every entry is in it's own cell

Here's what I'd like to end up with:

..Name..|..Title 1..|Author1|.....|..pub1..|.2.|0:05|
...........|.............|...........|....|...........|.2.|0:07|
...........|...Title 2..|Author2|....|..pub1..|.2.|0:12|
...........|.............|...........|....|...........|.2.|0:19|
...........|.............|...........|....|...........|.2.|0:05|

I had to put dots in for formatting on the post, but essentially the dots are empty lines within the cell. Essentially, I'd like all this information in one row. I'm hoping I can put false carriage returns in to separate the rows (Alt+Enter). I really need to clearly differentiate the different durations and what title, author and publisher they come from.

Any help would be greatly appreciated.

 

[pcc]

A pivot table will do what you want...

 

[Windyisle]

Heya,

I'm not sure I know how to make that work. Mainly because this data is going to be inserted into a larger database. Most of the records in the database are already one row, and I'm trying to figure out a way to include records that have information that needs to be displayed in multiple rows in the same database. So I thought that if I merged the multi-record data into single rows then they would work with all the other calculations I have going on.

So I don't want an end result, I just want to modify the record so all the information is contained in one row.

Thanks,