ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Make stair columns (https://www.excelbanter.com/excel-worksheet-functions/56627-make-stair-columns.html)

Chunrima

Make stair columns
 
Hi..there
If you have any clue, please help me out.
I have the values in A column below
A
B
C
D
E
F
G
H
I
J
K
L
But I wold like to get:
A
B D
C E G
F H J
I K
L

Thank you.


Dave R.

Make stair columns
 
The ouput you want is kind of garbled, looks like you want 3 rows in each
stair (where possible)?

What is this for?



"Chunrima" wrote in message
oups.com...
Hi..there
If you have any clue, please help me out.
I have the values in A column below
A
B
C
D
E
F
G
H
I
J
K
L
But I wold like to get:
A
B D
C E G
F H J
I K
L

Thank you.




Chunrima

Make stair columns
 
This is more lined-up
A
B D
C E G
F H J
I K
L


Dave Peterson

Make stair columns
 
You have a reply at your post in .misc.

Chunrima wrote:

Hi..there
If you have any clue, please help me out.
I have the values in A column below
A
B
C
D
E
F
G
H
I
J
K
L
But I wold like to get:
A
B D
C E G
F H J
I K
L

Thank you.


--

Dave Peterson


All times are GMT +1. The time now is 05:27 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com