Anonymous321
New Member
- Joined
- Oct 12, 2021
- Messages
- 32
- Office Version
- 365
- Platform
- Windows
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
What I want to convert it too
Any help will be appreciated, thanks
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