More information: I figured out that I can carry over data to the
appropriate column with the following formula (using data on ID # 123 as an
example):

In column E6, I can use: =IF(B6="HCC",C6,"")

But, that only brings the value over to the correct column in the same row
where that code is. I want to bring that value up to the first row for that
employee.

"richzip" wrote:

I have what is probably a unique question, and kind of hard to explain, so I
have included a sample of how it should look. I have data in a pivot table
on Excel. It consists of employee 3, a pay code, and hours belonging to that
pay code. Each employee could have 1, 2, 3 (or more) rows of data. I want
the copy the employee's hours within the pivot table to columns that are not
within the pivot table. All of the hours have to show up on the top row for
that employee, and under a column specific to that pay code.

Below, I have a sample of how I want this to look:

(columns A, B, and C contain the pivot table; columns D and on are where I
want to copy the hours from column C. The hours should be copied to the top
row for that employee; and to the column that corresponds to the code
indicated in column B

A B C D E F
G
1 REG HCC ITC
SCC
2
3 ID Code Hours
4 123 REG 57.10 57.10 5.82 22.43
5 ITC 22.43
6 HCC 5.82
7
8 456 REG 62.25 62.25 27.15 3.5
9 ITC 27.15
10 SCC 3.50
11
12 789 REG 61.50 61.50 25.6
13 ITC 25.6