Merging several rows into one row will delete data in all the rows except the first one. If you want to see all the data at one time,then you have to zoom out the window so that all rows are visible on the screen. But if you want the data in all rows to show up in one cell, then you have to create another row and concatenate the data of all the rows. For example, if you have data from B to AZ, create this formula in the column after AZ: =B1&C1&D1....until AZ. This will merge all data in the columns into one cell at the end.

Hope this is what you wanted.