Converting date columns into numbered months

[Anonymous321]

Hey everyone
I'm struggling to think of a title that accurate describes what I want to do. Pretty much I have a columns with each month of the year, with the rows containing products, with the sale data being present in each cell under a certain month for each product. My question is, is it possible to convert this table so it shows how well the product has done for the first 12 months of its existence. For example, instead of a Table, having 15 sales under March 2022 (the first month of sales), it tells me there were 15 sales in its first month. This will be the idea for all products no matter when the we started to sell the product. Hopefully the tables below will help explain this better.


What I have now

Product	Jan 2022	Feb 2022	March 2022	April 2022
Table	0	0	5	6
Chair	3	1	2	0

What I want to convert it too

Product	Month 1	Month 2	Month 3	Month 4
Table	5	6
Chair	3	1	2	0

Any help will be appreciated, thanks

 

[Phuoc]

Try this

Book1
	A	B	C	D	E
1	Product	Jan-22	Feb-22	Mar-22	Apr-22
2	Table	0	0	5	6
3	Chair	3	1	2	0
4
5	What I want to convert it too
6	Product	Month 1	Month 2	Month 3	Month 4
7	Table	5	6
8	Chair	3	1	2
Sheet1

Cell Formulas
Range	Formula
B7:E8	B7	=IFERROR(INDEX($B2:$E2,AGGREGATE(15,6,COLUMN($B2:$E2)/($B2:$E2<>0),COLUMNS($B7:B7))-1),"")

 

[Anonymous321]

Try this

Book1
	A	B	C	D	E
1	Product	Jan-22	Feb-22	Mar-22	Apr-22
2	Table	0	0	5	6
3	Chair	3	1	2	0
4
5	What I want to convert it too
6	Product	Month 1	Month 2	Month 3	Month 4
7	Table	5	6
8	Chair	3	1	2
Sheet1

Cell Formulas
Range	Formula
B7:E8	B7	=IFERROR(INDEX($B2:$E2,AGGREGATE(15,6,COLUMN($B2:$E2)/($B2:$E2<>0),COLUMNS($B7:B7))-1),"")

This works, but I should probably have been more clear as to what I'm looking for. The two tables won't have the same order in the first column (e.g., "Tables" wont necessary be at the top of the bottom table). I also should've said that there would also be a column between the Product and Jan-22 columns, with the colour of the product (e.g. you would have two rows for Table black, and table white). I've added amended tables below. Apologies again, should've explained what I was looking for a bit more clearly.

Old table

Product	Colour	Jan 22	Feb 22	Mar 22	Apr 22
Table	Black	0	0	10	15
Table	White	0	6	9	23
Chair	Brown	5	6	7	6
Chair	Grey	4	2	3	0

What I'm looking for

Product	Colour	Month 1	Month 2	Month 3	Month 4
Chair	Grey	4	2	3	0
Chair	Brown	5	6	7	6
Table	Black	10	15
Table	White	6	9	23