Excel Formula Help

[faberem20]

I have a spreadsheet with the following columns:

3​	Corn Belt Wireless, Inc.	9-Dec​	220​
3​	Corn Belt Wireless, Inc.	10-Jan​	220​
3​	Corn Belt Wireless, Inc.	10-Feb​	220​
3​	Corn Belt Wireless, Inc.	10-Mar​	220​
3​	Corn Belt Wireless, Inc.	10-Apr​	290​
3​	Corn Belt Wireless, Inc.	10-May​	290​
3​	Corn Belt Wireless, Inc.	10-Jun​	290​
3​	Corn Belt Wireless, Inc.	10-Jul​	410​
3​	Corn Belt Wireless, Inc.	10-Aug​	360​
3​	Corn Belt Wireless, Inc.	10-Sep​	360​
3​	Corn Belt Wireless, Inc.	10-Oct​	460​
3​	Corn Belt Wireless, Inc.	10-Nov​	430​
3​	Corn Belt Wireless, Inc.	10-Dec​	460​
3​	Corn Belt Wireless, Inc.	11-Jan​	460​
3​	Corn Belt Wireless, Inc.	11-Feb​	460​
3​	Corn Belt Wireless, Inc.	11-Mar​	680​
3​	Corn Belt Wireless, Inc.	11-Apr​	460​
3​	Corn Belt Wireless, Inc.	11-May​	460​
3​	Corn Belt Wireless, Inc.	11-Jun​	510​
3​	Corn Belt Wireless, Inc.	11-Jul​	530​
3​	Corn Belt Wireless, Inc.	11-Aug​	530​
3​	Corn Belt Wireless, Inc.	11-Sep​	530​
3​	Corn Belt Wireless, Inc.	11-Oct​	530​
3​	Corn Belt Wireless, Inc.	11-Nov​	530​
3​	Corn Belt Wireless, Inc.	11-Dec​	580​
3​	Corn Belt Wireless, Inc.	12-Jan​	580​
3​	Corn Belt Wireless, Inc.	12-Feb​	580​
3​	Corn Belt Wireless, Inc.	12-Mar​	630​
3​	Corn Belt Wireless, Inc.	12-Apr​	630​
3​	Corn Belt Wireless, Inc.	12-May​	630​
3​	Corn Belt Wireless, Inc.	12-Jun​	630​
3​	Corn Belt Wireless, Inc.	12-Jul​	630​
3​	Corn Belt Wireless, Inc.	12-Aug​	630​
3​	Corn Belt Wireless, Inc.	12-Sep​	630​
3​	Corn Belt Wireless, Inc.	12-Oct​	630​
3​	Corn Belt Wireless, Inc.	12-Nov​	630​
8​	DMCI Broadband LLC	9-Dec​	760​
8​	DMCI Broadband LLC	10-Jan​	780​
8​	DMCI Broadband LLC	10-Feb​	780​
8​	DMCI Broadband LLC	10-Mar​	820​
8​	DMCI Broadband LLC	10-Apr​	820​
8​	DMCI Broadband LLC	10-May​	860​
8​	DMCI Broadband LLC	10-Jun​	900​
8​	DMCI Broadband LLC	10-Jul​	900​
8​	DMCI Broadband LLC	10-Aug​	940​
8​	DMCI Broadband LLC	10-Sep​	940​
8​	DMCI Broadband LLC	10-Oct​	940​

The list above goes for about 18k rows. How do I take this data and put it into the following format on a separate tab:

Customer Number

Customer Name

9-Dec​

10-Jan​

10-Feb​

10-Mar​

10-Apr​

10-May​

10-Jun​

10-Jul​

10-Aug​

10-Sep​

10-Oct​

10-Nov​

10-Dec​

11-Jan​

11-Feb​

11-Mar​

11-Apr​

11-May​

11-Jun​

11-Jul​

11-Aug​

11-Sep​

11-Oct​

11-Nov​

11-Dec​

12-Jan​

12-Feb​

12-Mar​

12-Apr​

12-May​

12-Jun​

12-Jul​

12-Aug​

12-Sep​

12-Oct​

12-Nov​

12-Dec​

13-Jan​

13-Feb​

13-Mar​

13-Apr​

13-May​

13-Jun​

13-Jul​

13-Aug​

13-Sep​

13-Oct​

13-Nov​

13-Dec​

14-Jan​

14-Feb​

14-Mar​

14-Apr​

14-May​

14-Jun​

14-Jul​

14-Aug​

14-Sep​

14-Oct​

14-Nov​

14-Dec​

15-Jan​

15-Feb​

15-Mar​

15-Apr​

15-May​

15-Jun​

15-Jul​

15-Aug​

15-Sep​

15-Oct​

15-Nov​

15-Dec​

16-Jan​

16-Feb​

16-Mar​

16-Apr​

16-May​

16-Jun​

16-Jul​

16-Aug​

16-Sep​

16-Oct​

16-Nov​

16-Dec​

17-Jan​

17-Feb​

17-Mar​

17-Apr​

17-May​

17-Jun​

17-Jul​

17-Aug​

17-Sep​

17-Oct​

17-Nov​

17-Dec​

3​

Corn Belt Wireless, Inc.

 

[Fluff]

What version of Xl are you using?
If you goto into Account Settings, you can select your version & Platform, so that will shows in your mini-profile

 

[faberem20]

What version of Xl are you using?
If you goto into Account Settings, you can select your version & Platform, so that will shows in your mini-profile

Office Professional Plus 2019
Version 2003 Build 12624.20382

 

[Fluff]

Thanks for that, can you lease update your profile. It saves members having to ask

 

[Fluff]

How about

+Fluff.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO
1	Customer Number	Customer Name	09-Dec	10-Jan	10-Feb	10-Mar	10-Apr	10-May	10-Jun	10-Jul	10-Aug	10-Sep	10-Oct	10-Nov	10-Dec	11-Jan	11-Feb	11-Mar	11-Apr	11-May	11-Jun	11-Jul	11-Aug	11-Sep	11-Oct	11-Nov	11-Dec	12-Jan	12-Feb	12-Mar	12-Apr	12-May	12-Jun	12-Jul	12-Aug	12-Sep	12-Oct	12-Nov	12-Dec	13-Jan	13-Feb
2	3	Corn Belt Wireless, Inc.	220	220	220	220	290	290	290	410	360	360	460	430	460	460	460	680	460	460	510	530	530	530	530	530	580	580	580	630	630	630	630	630	630	630	630	630
3	8	DMCI Broadband LLC	760	780	780	820	820	860	900	900	940	940	940
Sheet2

Cell Formulas
Range	Formula
C2:AO3	C2	=IFERROR(INDEX(Sheet1!$D$2:$D$100,AGGREGATE(15,6,(ROW(Sheet1!$D$2:$D$100)-ROW(Sheet1!$D$2)+1)/(Sheet1!$B$2:$B$100=$B2),COLUMNS($A$1:A$1))),"")

 

[faberem20]

Is there a way for me to post the Excel file?

 

[Fluff]

Not to the site, but you can post to a share site, mark for sharing & post the link to the thread.
Did my suggestion work?

 

[par60056]

Looks like you might want to use a pivot table. Need column headers Put the customer number and name as row fields, date as a column field and the value in the values.

 

[faberem20]

Looks like you might want to use a pivot table. Need column headers Put the customer number and name as row fields, date as a column field and the value in the values.

Thanks!