Excel Task Question
-
I have been given a database with data in this format:
Company Person1 Person2 Person3
and would like it
Company Person1
Company Person2
Company Person3I am assuming I can just write a program the goes through each line X times and pulls out the data and write it to a new sheet.
But not knowing VB, I figured I'd check and see if anyone had already done something like this and had any suggestions/code.
-
That's a basic pivot table
-
@JaredBusch said in Excel Task Question:
That's a basic pivot table
I've never used Pivot Tables in that manner. I don't see how you could do what I am looking to do with a pivot table but I do not use them as much as you, perhaps.
The company is not changing. So there are 4 people in each row who need 4 new rows with all the data from the company in the same row.
-
OK so it's a complicated pivot table but it still a pivot
