Consolidating Columns

[Dastnai]

Hello Everyone,

Does anyone know of a way to turn multiple Columns into one column. For example, I am looking to have one column with 20/40, 30/50, 40/70 and 100M. Then the other columns will contain Avg LT, Replenish LT etc. Please note this is actually 95 total columns with multiple formulas.




Current:

BP#	Site	Basin	20/40 Max	30/50 Max	40/70 Max	100M Max	20/40 Min	30/50 Min	40/70 Min	100M Min	20/40 Inv	30/50 Inv	40/70 Inv	100M Inv
9701	CIG-Von Ormy	EAG	17	15	15	17	17	15	16	17	10	10	10	10
9704	CIG-Loving	PRM	17	15	15	17	17	17	16	17	7	7	2	2
9705	CIG-Lubbock	PRM	17	15	15	17	22	15	16	19	10	10	2	2
9708	Granite Peak-Rock Springs	NIO	17	15	15	17	17	15	15	17	10	10	10	10
9711	Equalizer-Victoria	EAG	30	30	30	30	30	30	30	30	10	10	10	10
9713	Maalt-Enid	MID	17	15	15	3	17	15	18	13	10	10	10	10

<colgroup><col><col><col><col span="12"></colgroup><tbody>
</tbody>

Desired outcome:

BP#	Site	Basin	Grade	Max	Min	Inv	ROP
9701	CIG-Von Ormy	EAG	20/40	0	0	0	0
9701	CIG-Von Ormy	EAG	30/50	17889	0	7	0
9701	CIG-Von Ormy	EAG	40/70	14019	1095	10206	2519
9701	CIG-Von Ormy	EAG	100M	2930	0	11163	0

<colgroup><col><col span="2"><col span="3"><col><col></colgroup><tbody>
</tbody>

.
.
.
.
.
.
.
.

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1075783-column-rows-question.html#post5167985

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).