Transpose Multi-Criteria

[tullibee_57]

Brand new member. Currently working on a GIS project and trying to format County Precipitation Data for a 30-year period.

I need to transpose the TOTAL_PRECIP values into columns 1980-2010 for each FIPSID (county). They are currently arranged in 30-year (1980-2010) rows for each FIPSID. See attached image below, hopefully what I'm wanting to do is explanatory.

I've poured through google and tried numerous formulas, nothing has seemed to work. Any help would be appreciated!

 

[Fluff]

Hi & welcome to MrExcel.
How about

Excel 2013/2016
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1	FIPSID				1980	1981	1982	1983	1984	1985	1986	1987	1988	1989	1990	1991	1992	1993
2	1001	1980	1	1001	1	2	3	4	5	6	7	8	9	10	11	12	13	14
3	1001	1981	2	1003	32	33	34	35	36	37	38	39	40	41	42	43	44	45
4	1001	1982	3
5	1001	1983	4
6	1001	1984	5
7	1001	1985	6
8	1001	1986	7
9	1001	1987	8
10	1001	1988	9
11	1001	1989	10
12	1001	1990	11
13	1001	1991	12
14	1001	1992	13
15	1001	1993	14
33	1003	1980	32
34	1003	1981	33
35	1003	1982	34
36	1003	1983	35
37	1003	1984	36
38	1003	1985	37
39	1003	1986	38
Sheet1

Cell Formulas
Range	Formula
D2	=IFERROR(INDEX(A$2:A$63,MATCH(0,INDEX(COUNTIF(D$1:D1,A$2:A$63),0),0)),"")
E2	=IFERROR(INDEX($C$2:$C$63,AGGREGATE(15,6,(ROW($C$2:$C$63)-ROW($C$2)+1)/($A$2:$A$63=$D2),COLUMNS($A1:A1))),"")

 

[Fluff]

Cross posted https://www.excelforum.com/excel-formulas-and-functions/1273160-transpose-multi-criteria.html

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.