Help! need help moving data from columns

John_Smith123456

New Member
Joined
Nov 12, 2022
Messages
1
Office Version
  1. 365
Platform
  1. Windows

Please help looking up values/ cells​



Hi!

I need some help please! I have a set of data with customers that has name in the 1st column, and the 2 different sales figures in a corroponding column. When i sort it, it list them on the rows- what I want to know is how to calculate the difference between to two figures, or plaace the two sales figures in different columns on the same row as the customer name.


So it looks like this now:


Customer Sales Period
AAA Customer 50
BBB Customer 70
AAA Customer 60
BBB Customer 30

Customer Sales Period
AAA Customer 50
AAA Customer 60
BBB Customer 70
BBB Customer 30

And I'd like it to look like this:

Customer Sales Period 1 Sales Period 2
AAA Customer 50 60
BBB Customer 30 70

Thanks so much!!
 
Last edited by a moderator:

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
There are quite a few different ways of achieving this.
Power Query or VBA could do it.
Below is an options with adding a formula then using a pivot table.

Book2
ABCDEFGH
1CustomerSales AmtPeriodSum of Sales AmtPeriod
2AAA Customer501Customer12Grand Total
3BBB Customer701AAA Customer5060110
4AAA Customer602BBB Customer7030100
5BBB Customer302Grand Total12090210
Sheet1
Cell Formulas
RangeFormula
C2:C5C2=COUNTIFS(A$2:A2,A2)
 
Upvote 0
Another option
Fluff.xlsm
ABCDEF
1CustomerSales Amt
2AAA Customer50AAA Customer5060
3BBB Customer70BBB Customer7030
4AAA Customer60
5BBB Customer30
Details
Cell Formulas
RangeFormula
D2:D3D2=UNIQUE(FILTER(A2:A100,A2:A100<>""))
E2:F3E2=TRANSPOSE(FILTER($B$2:$B$100,$A$2:$A$100=D2))
Dynamic array formulas.
 
Upvote 0

Forum statistics

Threads
1,213,543
Messages
6,114,237
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top