Hi,
I have a spreadsheet that has 2 tables in it and looks like this:
Seller, Type, Oct, Nov, Dec
John, 1, 20, 30, 40
John, 2, 50, 60, 70
Seller, Type, Aug, Sept, Dec
Cara, 1, 10, 20, 30
Cara, 2, 40, 50, 60
I am trying to rearrange the data such that it looks like this:
Seller, Type, Aug, Sept, Oct, Nov, Dec
John, 1, 0, 0, 20, 30, 40
Jonh, 2, 0, 0, 50, 60, 70
Cara, 1, 10, 20, 0, 0, 30
Cara, 2, 40, 50, 0, 0, 60
Have tried sumif, treating the data as an array as well as the index and match function in excel but unable to do it.
The problem I am facing is that the header of both tables are not the same ie the months, therefore was wondering if there is another around it (without changing the headers of both tables).
Thanks
Desperate and having a headache.
I have a spreadsheet that has 2 tables in it and looks like this:
Seller, Type, Oct, Nov, Dec
John, 1, 20, 30, 40
John, 2, 50, 60, 70
Seller, Type, Aug, Sept, Dec
Cara, 1, 10, 20, 30
Cara, 2, 40, 50, 60
I am trying to rearrange the data such that it looks like this:
Seller, Type, Aug, Sept, Oct, Nov, Dec
John, 1, 0, 0, 20, 30, 40
Jonh, 2, 0, 0, 50, 60, 70
Cara, 1, 10, 20, 0, 0, 30
Cara, 2, 40, 50, 0, 0, 60
Have tried sumif, treating the data as an array as well as the index and match function in excel but unable to do it.
The problem I am facing is that the header of both tables are not the same ie the months, therefore was wondering if there is another around it (without changing the headers of both tables).
Thanks
Desperate and having a headache.