How do I insert cells so the each data sub-set has 3 rows only

[JeffGrant]

Hi All,

I thought it would be simple, but apparently not. In the attached sheet, I have a column of data where some data sets have 3 rows, some have 2 rows and some have 1 row.

It is important that all data sets have 3 rows. How do I go about automatically inserting rows, so that each data set has 3 rows and they must be grouped together?

This is important because:
1. The imported data comes in a single column and can have varying grouped data lengths of 1, 2 or 3 rows per set as in the spreadsheet.
2. These data sets form the X values in a linear regression
3. Unless there is a way to run a linear regression with a "dynamic" number of X values, it is much simpler and faster to make sure that there are 3 X values every time, even if some of them are set to a zero value.

The total number of rows in the imported data will vary.

I suspect this will require a VBA routine.

Just had another thought.
Is there a way to determine length of the data sets and transpose from a single column into an array?
I note that there are some solutions that do this as long as as all data sub-sets have the same number of entries in the column.

Any guidance is very graciously accepted.

Jeff.

[torachan]

looking at your sample, do you really mean "must have three rows" or should it be "must have three columns". ?

[JeffGrant]

Hi Torachan.....

I need to end up with 3 columns for the linear regression. Each row is for a different linear regression.

But the data comes is as one single column. As I have shown in the spreadsheet, the imported data can have 3 x A, 2 x B, 1 x C etc as shown in Column A. So I need to add the extra 1 x B and 2 x C etc in Column A, the single column so that I get 3 x everything that can be transposed into columns E,F & G.

The transposed data is for 1 linear regression per line, using 3 x A in one LR and 3 x B in the next LR and 3 x C in the next and so on.

Does that make a bit more sense ?

[JeffGrant]

Update...

I managed to find a solution at:

https://www.extendoffice.com/documen...to-column.html

This works perfectly and can be adapted to be used on my LR's.

Thanks for your help.