Multiple Values Lookup
 

I have data in Column A, B and C. Is there any way to populate from Column F
to Column J by Year and by Type? What about the data covering more than 2
years. i.e 2005, 2006, 2007 and 2008.

Source Data could have skipped a line and continued after (see below).

Year Type Amount
2008 Principal 320.97
2008 Principal (309.11)
2008 Principal (80.28)
2008 Principal 318.76
2008 Principal (304.92)
2008 Principal (85.10)
2007 Principal (221.24)
2007 Principal (72.80)

2007 Principal 554.33
2007 Principal (52.05)
2007 Principal (60.61)

2007 Interest 28.35
2008 Charge 140.00
2008 Charge (99.00)
2008 Interest (619.02)
2007 Charge 133.45
2007 Charge (67.88)
2007 Interest (3.45)
2008 Interest 678.45

Want to Show

Column E Column F Column G Column H Column I Column J

2007 2007 2007 2008 2008 2008
Principal Interest Charge Principal Interest Charge

(221.24) 28.35 133.45 320.97 (619.02) 140.00
(72.80) (3.45) (67.88) (309.11) 678.45 (99.00)
554.33 (80.28)
(52.05) 318.76
(60.61) (304.92)
(85.10)

Multiple Values Lookup
 

Use a Pivot Table. See:

http://peltiertech.com/Excel/Pivots/pivotstart.htm
--
Gary''s Student - gsnu200778


"igbert" wrote:

I have data in Column A, B and C. Is there any way to populate from Column F
to Column J by Year and by Type? What about the data covering more than 2
years. i.e 2005, 2006, 2007 and 2008.

Source Data could have skipped a line and continued after (see below).

Year Type Amount
2008 Principal 320.97
2008 Principal (309.11)
2008 Principal (80.28)
2008 Principal 318.76
2008 Principal (304.92)
2008 Principal (85.10)
2007 Principal (221.24)
2007 Principal (72.80)

2007 Principal 554.33
2007 Principal (52.05)
2007 Principal (60.61)

2007 Interest 28.35
2008 Charge 140.00
2008 Charge (99.00)
2008 Interest (619.02)
2007 Charge 133.45
2007 Charge (67.88)
2007 Interest (3.45)
2008 Interest 678.45

Want to Show

Column E Column F Column G Column H Column I Column J

2007 2007 2007 2008 2008 2008
Principal Interest Charge Principal Interest Charge

(221.24) 28.35 133.45 320.97 (619.02) 140.00
(72.80) (3.45) (67.88) (309.11) 678.45 (99.00)
554.33 (80.28)
(52.05) 318.76
(60.61) (304.92)
(85.10)

Multiple Values Lookup
 

Hi Gary's Student,

The data source populated from another document which included the blank
rows between records. Pivot Table does not work without removing the blank
rows. Is there any Excel formula to make it work?

Manyt thanks.

Igbert


"Gary''s Student" wrote:

Use a Pivot Table. See:

http://peltiertech.com/Excel/Pivots/pivotstart.htm
--
Gary''s Student - gsnu200778


"igbert" wrote:

I have data in Column A, B and C. Is there any way to populate from Column F
to Column J by Year and by Type? What about the data covering more than 2
years. i.e 2005, 2006, 2007 and 2008.

Source Data could have skipped a line and continued after (see below).

Year Type Amount
2008 Principal 320.97
2008 Principal (309.11)
2008 Principal (80.28)
2008 Principal 318.76
2008 Principal (304.92)
2008 Principal (85.10)
2007 Principal (221.24)
2007 Principal (72.80)

2007 Principal 554.33
2007 Principal (52.05)
2007 Principal (60.61)

2007 Interest 28.35
2008 Charge 140.00
2008 Charge (99.00)
2008 Interest (619.02)
2007 Charge 133.45
2007 Charge (67.88)
2007 Interest (3.45)
2008 Interest 678.45

Want to Show

Column E Column F Column G Column H Column I Column J

2007 2007 2007 2008 2008 2008
Principal Interest Charge Principal Interest Charge

(221.24) 28.35 133.45 320.97 (619.02) 140.00
(72.80) (3.45) (67.88) (309.11) 678.45 (99.00)
554.33 (80.28)
(52.05) 318.76
(60.61) (304.92)
(85.10)

Multiple Values Lookup
 

Pivottables will work with empty rows in the data.

Make sure you select the entire range, though.

igbert wrote:

Hi Gary's Student,

The data source populated from another document which included the blank
rows between records. Pivot Table does not work without removing the blank
rows. Is there any Excel formula to make it work?

Manyt thanks.

Igbert

"Gary''s Student" wrote:

Use a Pivot Table. See:

http://peltiertech.com/Excel/Pivots/pivotstart.htm
--
Gary''s Student - gsnu200778


"igbert" wrote:

I have data in Column A, B and C. Is there any way to populate from Column F
to Column J by Year and by Type? What about the data covering more than 2
years. i.e 2005, 2006, 2007 and 2008.

Source Data could have skipped a line and continued after (see below).

Year Type Amount
2008 Principal 320.97
2008 Principal (309.11)
2008 Principal (80.28)
2008 Principal 318.76
2008 Principal (304.92)
2008 Principal (85.10)
2007 Principal (221.24)
2007 Principal (72.80)

2007 Principal 554.33
2007 Principal (52.05)
2007 Principal (60.61)

2007 Interest 28.35
2008 Charge 140.00
2008 Charge (99.00)
2008 Interest (619.02)
2007 Charge 133.45
2007 Charge (67.88)
2007 Interest (3.45)
2008 Interest 678.45

Want to Show

Column E Column F Column G Column H Column I Column J

2007 2007 2007 2008 2008 2008
Principal Interest Charge Principal Interest Charge

(221.24) 28.35 133.45 320.97 (619.02) 140.00
(72.80) (3.45) (67.88) (309.11) 678.45 (99.00)
554.33 (80.28)
(52.05) 318.76
(60.61) (304.92)
(85.10)





--

Dave Peterson