Home

Is using a pivot table for this the right choice?

RSchwarz84
Occasional Visitor

Dear fellow community members,

 

I have the following problem. For our community yard sale we have given out numbers to people who want to sell things. The list I have has all 90 numbers in column A and the names in column B. People can reserve up to 3 numbers.

For the envelopes in which the money is put after the yard sale is over, I need a different table with the names in column A and the numbers in column B -D. I have tried using a pivot table, but it keeps summing up the numbers.

What am I missing here?

Can somebody help me? Maybe a pivot table isn't the right choice and I need to use VLOOKUP?

 

Thanks in advance,

Rose

1 Reply

@RSchwarz84 , PivotTable works if you add helper column to your data to calculate sequential number of numbers for each name, could be as

=COUNTIF($B$2:$B2,B2)

and drag it down. Pivot all three columns, names in rows, sequence in columns and numbers as values.

image.png

Please see the sample attached

 

Related Conversations
PivotTable : Unexpected behavior with 2 tables
CastyChichi in Excel on
2 Replies
Set Auto Refresh to Pivot Table as Source Data Changes
ratishkp in Excel on
2 Replies
Counting Days
Tim Hunter in SQL Server on
2 Replies
PWA fullscreen like IE11 kiosk mode
rogihee in Discussions on
5 Replies