Pivot tables 2 row labels

  • Thread starter Thread starter sdav
  • Start date Start date
S

sdav

I am trying to create a pivot table and want to have sales rep names and
company as the rows. Is there a way to have the sales rep name repeat
everytime with the company instead of how it looks below? I am going to have
to use the output of the sheet to do a vlookup on another sheet and in this
format I can't make it work. Thanks!

Row Labels
Jane Doe
Company 1
John Doe
Company 2
Company 1
Company 3
Company 5
 
I don't want to keep it as a pivot table. It is a large spreadsheet so I was
trying to move everything manually.

The site you shared with the copying is great. I will use that info once I
get the data into 2 separate columns.
 
I can't find the video on the site you shared anymore. I was going to follow
the written instructions, but don't know where to find edit.
 
Back
Top