Formatting LAS files (blocks of data that should be across one row)

[farrellj66]

I am trying to format a large amount of data that comes up like this...

1
1 2 3 4 5
6 7 8 9 10
11 12 13 14 15
16 17 18 19 20

2
1 2 3 4 5
6 7 8 9 10
11 12 13 14 15
16 17 18 19 20

....

I would like to have the bold numbers going down a single column. The remaining numbers i would like to paste across the remaining row. to appear like this...

1 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
2 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20


Please help me!!!

 

[hiker95]

farrellj66,

Welcome to the MrExcel forum.

1. What version of Excel, and, Windows are you using?

2. Are you using a PC or a Mac?


Based on your flat text display:

We can not tell where your raw data is located, sheet name, cells, cell formatting, rows, columns, and, we can not tell where the results should be, sheet name, cells, cell formatting, rows, columns.

To start off, and, so that we can get it right on the first try:

Can you post a screenshot of the actual raw data worksheet?

And, can you post a screenshot of the worksheet results (manually formatted by you) that you are looking for?

To post a small screen shot (NOT a graphic, or, picture, or, PNG file, or, flat text) try one of the following:

MrExcel HTML Maker
If you do not know how to install and how to use HTML Mr.Excel Maker
https://www.youtube.com/watch?v=JycvgGppxt0&feature=youtu.be

Excel Jeanie
Download

Borders-Copy-Paste
http://www.mrexcel.com/forum/about-board/444901-how-create-table-like-aladin.html#post2198045

To test the above:
Test Here


The following is a free site:

Or, you can upload your workbook to (the BLUE link-->) Box Net ,
sensitive data changed
mark the workbook for sharing
and provide us with a link to your workbook.