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
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies